Performance

This section lists down Performance Tuning articles

• Limiting I/O and CPU resources using 11g Oracle Resource Manager
• Checking column usage information using dbms_stats
• Poll on Sql Plan Management
• Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins
• Plan Stability using Sql Profiles and SQL Plan Management
• V$SQL_SHARED_CURSOR in 11.2.0.2
• 11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
• dbms_stats.copy_table_stats does not alter low/high value
• Index Access best approach?? Not Always…
• 11g New Feature: Database Replay
• ORA- 4031 – A Case Study
• Tracing Sessions with Event 10046
• Application Design and ORA – 4031
• Tweaking _Shared_pool_reserved_min_alloc and ORA – 4031
• HW enqueue contention with LOB
• Shared Sub Pools
• Diagnostics For Database Hang