Oracle Performance and tuning Oracle meta-link Notes.

Oracle Performance and tuning Oracle meta-link Notes.

1) How To Diagnose Why an Identical Query Has Different Plans in Different Environments (Doc ID 1671642.1)

2) Clustering Factor (Doc ID 39836.1)

3) Document 1386036.1 How To Diagnose Issues Where Plans Are Different From Different Clients

4) Document 604256.1 Why is a Particular Query Slower on One Machine (or Instance)

5) Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention (Doc ID 62143.1)

6) Troubleshooting Query Performance Degradation - Recommended Actions (Doc ID 742112.1)

7) TROUBLESHOOTING: Tuning Slow Running Queries (Doc ID 179668.1)

8) How to Use AWR Reports to Diagnose Database Performance Issues (Doc ID 1359094.1)

9) How to Tell if the I/O of the Database is Slow (Doc ID 1275596.1)

10)Diagnosing Why a Query is Not Using an Index (Doc ID 67522.1)

11)Troubleshooting: High Version Count Issues (Doc ID 296377.1)

12) Troubleshooting: High CPU Utilization (Doc ID 164768.1)