Wednesday, November 27, 2013

RDBMS -- Oracle Database Presentation

Acutally I have prepared and presented this presentation to developer who have been using Oracle Database for development and data analysis. I tried to create a dba perspective on them.
In this presentation, you can find the following topics;

Click here to reach the slides of the presentation..

Presentation Name :
Oracle Database for Developers
File Name: ORACLE_DATABASE_snip_by_Earslan.ppsx


Contents:

Primary Components
Oracle Instance
Oracle Database
Memory Architecture(pga, sga, Shared pool, buffer cache, ...)
Processes (user,server,background)
Diagnostic Files
Trace Levels (Tracefiles, tkprof)
Redo & Undo
Commit
Async Commit
Rollback
Row Migration & Chaining
HWM
Indexes( stats, constraint , clustering factor, index and cbo, notes)
Locks (blocking locks, identifying, v$lock)
Cbo
Auto_trace (sqlplus)
Execution Plan / Explain Plan
Hints
Dictionary

References:
Tom Kyte //asktom.oracle.com
Richard Foote //Oracle Index Internals
Donald Burleson //dba-oracle.com
Pavan Kumar > pavandba.com
Natalka Roshak //What is blocking my lock
Michael Messina // Indiana University
Oracle // docs.oracle.com

No comments :

Post a Comment