Oracle SQL Tuning
Hi,
This Video shows you below things.
Oracle SQL Tuning.
1. Optimizer use
2. Concepts of plan stability.
3. Stored outlines
4. Hints and its use.
5. SQL trace and TKPROF
6. Query processing.
7. Explain Plan.
8.SQLplus autotrace
9. Managing stats
10. SQL tuning advisor