Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Missing Indexes

754320
Member Posts: 22
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
Ludwig
Answers
-
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 -
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
This discussion has been closed.