Oracle Database Resource Portfolio - Performance

Key Performance Articles 

Best Practice Documents

 

Best Practice Webcasts

The following Best Practice Webcasts are available:

Oracle Database Resource Manager	Recording	.pdf
How to achieve Plan Stability on 11g with SQL Plan Management (SPM)	Recording	.pdf
Best Practices: Proactive Data Collection to Troubleshoot DB Performance Issues	Recording	.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• SQL Tuning Health Check Script (SQLHC) [Document 1366133.1]
• SQL Tuning Health-Check Script (SQLHC) Video [Document 1455583.1]

Tools

Oracle Service Request Data Collection

• Performance Related Oracle Service Request Data Collection (SRDC) Articles [Document 1938786.1]

Tools

• Oracle Performance Diagnostic Guide (OPDG) [Document 390374.1]
• All About the SQLT Diagnostic Tool [Document 215187.1]
• Analysis of Active Session History (Ash) Online and Offline [Document 243132.1]
• OSWatcher Black Box User Guide (Includes: [Video]) [Document 301137.1]
• Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM and Sql Tuning Advisor [Document 276103.1]
• Automatic Workload Repository (AWR) Reports - Start Point [Document 1363422.1]
• FAQ- Statspack Complete Reference [Document 94224.1]
• Comprehensive Database Real Application Testing Diagnostic Information [Document 1287620.1]
• How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues [Document 376442.1]
• SQL_TRACE (10046), TKProf and Explain Plan - Overview Reference [Document 199081.1]

Troubleshooting Assistants

• Troubleshooting Performance Issues [Document 1543445.2]
• Diagnosing the Cause of a Slow Query [Document 1542608.2]
• SQL Performance Issues [Document 1542678.2]
• Get Assistance to understand and solve Oracle SQL issues [Document 1564632.2]
• Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files [Document 1550091.2]
• Get Assistance to Understand and Solve Oracle Resource Manager [Document 1606825.2]

Premium Knowledge Content Notes

• Information Center: Database Performance Overview [Document 1512292.2]
• Information Center: SQL Query Performance Overview [Document 1516494.2]
• Information Center: Real Application Testing [Document 1545782.2]

MOS Communities

• Database Tuning Community
• SQL Performance Community

How-To / FAQ / Troubleshooting

• Troubleshooting Performance Issues [Document 1377446.1]
• How To Investigate Slow or Hanging Database Performance Issues [Document 1362329.1]
• Troubleshooting Query Performance Degradation - Recommended Actions [Document 742112.1]
• Troubleshooting Upgrade Related Query Performance Degradation - Recommended Actions [Document 745216.1]
• Troubleshooting a Server Upgrade Resulting in Slow Query Performance [Document 160089.1]

Troubleshooting Webcasts

The following Performance Troubleshooting Webcasts are available:

Troubleshooting DB Performance Issues with AWR	Recording	.pdf
Recovery Manager - Performance Troubleshooting	Recording	.pdf / scripts

For other webcasts, refer to  Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings