Priodata Query Plan

[03-03-2006] Priodata is proud to announce the release of version 1.1 of PrioData Query Plan for Oracle. It is a graphical interface to browse the shared SQL area in the SGA (accessible through the V$SQL view), including complete SQL text (from V$SQLTEXT), the execution plan in V$SQL_PLAN and statistics from V$SQL_PLAN_STATISTICS_ALL, when available.

For more information on these views, read this article written by Ilidio J. Antunes, our consultant and author of this tool.

Supporting Oracle versions from 9.0.1 to 10g (despite the changes in these V$ views from version to version, the program is compatible with all of them, including the new Oracle 10g Express Edition), PrioData Query Plan is a very helpful tool to assist the DBA in the complex task of tuning SQL statements, and is available for a very affordable price.

You can download here a fully-functional trial version and use it for 30 days. After this period you must purchase a license or deinstall it from your computer.

Features

• 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.

Screenshots

Main Window

SQL Statement and Execution Plan View Window

Where Clause Assistant

Pricing

Pricing starts at USD 42.00 for a single license, but falls rapidly when you buy more licenses (in the same order). See the table below. This pricing strategy is ideal for companies that tested and approved the product and want all their employees to use it.