optimizer - DB performance - sql performance - various notes

 Information Center: Database Performance Overview (Doc ID 1512292.2)

Information Center: SQL Query Performance Overview (Doc ID 1516494.2)

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

SQL Tuning Health-Check Script (SQLHC)(Doc ID 1366133.1)

FAQ: SQL Health Check (SQLHC) Frequently Asked Questions(Doc ID 1417774.1)

Privileges Required to Run SQLHC Using Non SYS User(Doc ID 3005311.1)

SQL Tuning Health-Check Script (SQLHC) Video(Doc ID 1455583.1)

User Privileges Needs For Sqlhc to Run Other than SYS User(Doc ID 3000903.1)

SQL Tuning Health-Check Script (SQLHC) - ADB Specific(Doc ID 2857248.1)

OBIA: How to Create AWR and SQLHC Reports for Troubleshooting BIApps Performance Issues(Doc ID 2178049.1)

How to Collect Standard Diagnostic Information Using SQLHC for SQL Performance and Incorrect Result Issues(Doc ID 1903134.1)

SQLHC - Diagnostic/tuning Pack Called Even If License Specified As "N"(Doc ID 2981762.1)