content

Administration

• Generate DDL commands of existing objects
• index usage monitoring / invisible indexes
• instance caging
• rebuild index online fails with ora-8104
• reorganize tables online with dbms_redefinition
• setup resource manager in 11.1
• show hidden parameters
• some sql scripting hints
• sql plan management – how to fix an execution plan
• stored outlines – fixed execution plan

Installation Oracle / Unix

• easy, fast cloning ORACLE_HOME
• enable, disable options in 11.2
• unix scripts – hints

Tracing / diagnostics

• additional events
• ADR – Automatic Diagnostic Repository
• AWR – automatic workload repository
• bulk commit
• event 10046 – tracing sessions
• event 10053 – obtaining optimizer computations
• invalidate cursor in shared pool
• tkprof – analyze tracefiles