Forum Stats

  • 3,814,528 Users
  • 2,258,880 Discussions
  • 7,892,767 Comments

Discussions

Categories

Missing Indexes

754320
754320 Member Posts: 22
edited Apr 15, 2010 10:46AM in SQL & PL/SQL
Any idea if there is a tuning advisor (or any other tool) for Oracle DBAs which proposes the creation of an index to improve the performance of a particular query? Similar to the Microsoft SQL server Activity Monitor explain plan?

Ludwig
Tagged:
· Share on TwitterShare on Facebook

Answers

  • Hoek
    Hoek Member Posts: 16,087 Gold Crown
    edited Apr 15, 2010 10:46AM
    Yes, check the Oracle docs:
    http://download.oracle.com/docs/cd/B28359_01/server.111/b28301/montune003.htm#ADMQS103
    http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/montune.htm#ADMQS103

    Home of the Oracle docs:
    http://tahiti.oracle.com
    · Share on TwitterShare on Facebook
  • Gaff
    Gaff Member Posts: 1,490
    Absolutely! Oracle Grid Control/Enterprise Manager. Run your query and you'll be able to see it in the OEM GUI and have OEM analyze the query (or set of queries) and suggest tuning advise. The link is called SQL Adviser I believe? (Don't have it in front of me at the moment.)

    You don't say what version you have, and OEM has slightly different looks depending on its version, but this should get you started.

    http://developer.emc.com/developer/downloads/FAQ_Perf_Tuning_With_Oracle_Tuning_Advisor.pdf


    You can also do it through SQL, but I never do.
    http://www.databasejournal.com/features/oracle/article.php/3387011/Introduction-to-Oracle-10gs-New-SQL-Tuning-Advisor.htm
    · Share on TwitterShare on Facebook
This discussion has been closed.