As I said to the previous chapter, SQL Access Advisor is also related with the previous topic ("Use SQL tuning tools and features"), but was defined separately. This indicates that this it is also a very important and will probably be in the certification exam. Study it!
SQL Advisor is another performance tool and can suggest improvements like:
- Indexes.
- Mat Views.
- Partitions.
- Modify or Drop the above items.
You must need to know how to:
- Create a SQL Tuning Set and submit for SQL Advisor.
- Have a good look at DBMS_ADVISOR.
Try to use Enterprise Manager whenever possible. This will save you a good time! You can also use it to generate the script body and then adapt. Writing PL/SQL code will take your precious exam time!
Path to Documentation:
Performance Tuning Guide -> 18 SQL Access Advisor
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
