Papers and Presentations

Content usage subject to Terms Of Use

Guest Papers

An Industrial Engineer's Approach to Managing Oracle Databases paper and presentation. These apply Industrial Engineering principles to performance and the paper/presentation are very thought provoking.

Performance Papers

But Mogens, We Are Still Not Tuning The Right SQL Statements presentation
Effective Use of SQL Trace presentation
Performance Metrics using Statspack and Analytical SQL presentation
Comprehensive Approach to Performance Diagnosis presentation
Tuning and Troubleshooting for Developers/dbms_metadata (RMOUG) paper and presentations
Effective Performance for Developers and Users seminar paper. This includes my presenter notes in the body.

Recovery Papers

Real Life Recovery paper and presentation. These papers are a little old (first presented in 1999), but the principles still apply.

Internals

Tracing Logical I/O presentation and research
Automatic Undo Internals paper

SQL, PL/SQL and Packages

Effective Use of DBMS_METADATA presentation