Priodata Query Plan is a front-end to the most commonly used V$ views to investigate SQL execution performance in the Oracle Database. You can browse the shared cursor area looking for low-performance SQL, see all information related (taken from V$SQL view) and the complete SQL statement and its execution plan (taken from V$SQL_PLAN).

Also captures information from the optimizer statistics (last_analyzed and num_rows) and place together with the execution plan, improving analysis. All this with a fine graphical interface, without having to write your own queries and joins. Query Plan really improves performance of the process of tuning Oracle applications.

This product is ideal for consultants, DBAs and also application developers, because it automates some queries one must write in order to do a proper tuning of the database. Although the product is simple, it is innovative and the price is very low compared to other high-featured Oracle tools. Query Plan supports Oracle 0i and later.

Here are some key features of "Query Plan":

· Oracle connection through .NET Data Provider (no need to install any lib, only the Oracle Client).
· Stores recent connections list for convenience.
· Fine and intuitive user interface.
· Assistant Dialog to help the user edit the WHERE clause for selecting cursors.
· Practical User Manual.
· Resolves user id to user names.
· Automatic conversion of time units for elapsed time and CPU time for readability.
· Automatic retrieval of complete SQL statement piece-to-piece from V$SQLTEXT.
· Automatic retrieval of execution plan (from V$SQL_PLAN) and presentation in a tree view.


Requirements:

· .NET Framework 1.1


Limitations:

· 30 days trial