This chapter is very very hard. Why? Because you can rephrase this as: "you need to know all the oracle tools that can help you improve the performance of something".
So, what are those "tools" and "features". Well, there are a lot of them:
- First, the ones that have a specific topic already defined:
- SQL Performance Analyser
- SQL Tuning Advisor
- SQL Access Advisor
- Execution Plans
- Now, the ones that there is no topic defined (so study it here):
- AWR (Snapshots/Baselines)
- ADDM
- ASH
- DBMS_MONITOR
- Viewing Metric History Information
- SQL Profile
- SQL Plan Management
- All the Areas (Memory/Segments) Advisors Views
- Instance Activity and Wait Event Statistics
- Tuning I/O
- trcsess Utility
- Using tkproof
Pay attention: Whenever possible, try to use always the EM interface! It can make you save a lot of time!
Path to Documentation:
Performance Tuning Guide -> Everything
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
2 comments
Hi,
I could not find the path of the performance tuning guide
Author
It's under "Performance" main group. There you have "Performance Tuning Guide".