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