Query Plan

Priodata Query Plan is an exceptional software that serves as a front-end to the commonly used V$ views to investigate SQL execution performance in Oracle Database. This tool enables users to effortlessly browse the shared cursor area for low-performance SQL, examine all information related to it (taken from V$SQL view), and access the complete SQL statement and its execution plan (taken from V$SQL_PLAN).

Furthermore, this software captures information from optimizer statistics (last_analyzed and num_rows) and unifies it with the execution plan, providing more comprehensive analysis. The graphical interface of Query Plan is cleverly designed, transforming the process of analyzing SQL execution performance into a hassle-free task, eliminating the need for users to manually write queries and joins. The result is a marked improvement in the performance of tuning Oracle applications.

Query Plan is an ideal choice for consultants, DBAs, and application developers seeking to automate the queries required to perform a proper database tuning. This innovative software is simple to use, yet incredibly powerful in improving performance, and it comes at an extremely low price compared to other high-featured Oracle tools. Query Plan is compatible with Oracle 9i and later versions, making it readily accessible to a wide range of Oracle Database users.