OCM 11g Preparation - Use SQL tuning tools and features

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

    • sreenath rayachur on August 1, 2017 at 09:27
    • Reply

    Hi,

    I could not find the path of the performance tuning guide

    1. It's under "Performance" main group. There you have "Performance Tuning Guide".

Leave a Reply

Your email address will not be published.