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
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
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
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
If you will ask a question, please don't comment here..
For your questions, please create an issue into my forum.
Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html
Register and create an issue in the related category.
I will support you from there.