Oracle SQL Tuning with Oracle SQLTXPLAIN

1. Introduction to SQLTXPLAIN
Stelios Charalambides

2. The Cost-Based Optimizer Environment
Stelios Charalambides

3. How Object Statistics Can Make Your Execution Plan Wrong
Stelios Charalambides

4. How Skewness Can Make Your Execution Times Variable
Stelios Charalambides

5. Troubleshooting Query Transformations
Stelios Charalambides

6. Forcing Execution Plans Through Profiles
Stelios Charalambides

7. Adaptive Cursor Sharing
Stelios Charalambides

8. Dynamic Sampling and Cardinality Feedback
Stelios Charalambides

9. Using SQLTXPLAIN with Data Guard Physical Standby Databases
Stelios Charalambides

10. Comparing Execution Plans
Stelios Charalambides

11. Building Good Test Cases
Stelios Charalambides

12. Using XPLORE to Investigate Unexpected Plan Changes
Stelios Charalambides

13. Trace Files, TRCANLZR and Modifying SQLT behavior
Stelios Charalambides

14. Running a Health Check
Stelios Charalambides

15. The Final Word
Stelios Charalambides

Keywords: Computer Science, Database Management