QueryAdvisor is the universal tool for analysis, diagnosis, optimisation and forecasting of Oracle databases.
QueryAdvisor is a highly effective productivity tool for fast and comprehensive analysis of large amounts of Oracle trace files. It allows you to more efficiently manage and tune your database.
As such, it is intended for Database Administrators as well as Software Developers.
Since it is used in a separate, local session and only for generating the execution plans, the virtual index will remain invisible to anyone else. After executing the “Materialization” process, the virtual index is transformed into a real one. Again, these procedures are automatic and require no user interaction, which significantly reduces the risk of database failure.
Query Advisor is a highly effective productivity tool for fast and comprehensive analysis of large amounts of Oracle trace files. As such, it is intended for the Database Administrators as well as the software developers. The primary purpose of the Query Advisor is to assist you in performing the database maintenance tasks as well as to help you solve problems quickly and safely.
A brochure describing the major features of QueryAdvisor for download is available here.