SQL Tuning Advisor is a great tool. This item is related with the previous topic ("Use SQL tuning tools and features"), but was defined separately. This indicates that it is very important and will probably be in the certification exam.
SQL Tuning will suggest you to:
- Create a SQL Profile
- Create an Index
- Gather Statistics
- Restructure SQL
- Alternative Plan
You must need to know how to:
- Create a SQL Tuning Set and submit for SQL Tuning.
- Define Automatic SQL Tuning Windows Jobs.
- Run SQL Tuning for a single query.
- Have a good look at DBMS_AUTO_SQLTUNE.
Everything that I said above is very very hard to do using packages and writing. So, use Enterprise Manager! Don't think twice.
I personally don't believe the exam will constrain you to use CLI, because even for the most experts this would take time, and they want to test you in a lot of features. Anyway, be always prepared for anything. The official documentation has CLI steps to copy and paste.
Path to Documentation:
Performance Tuning Guide -> 17.3 Tuning Reactively with SQL Tuning Advisor
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
