Query Plan for Oracle. Query Plan 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.

Supporting Oracle versions from 9.0.1 to 10g (despite the changes in these V$ views from version to version, Query Plan 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.

Features of Priodata 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.

Query Plan is designed for:
Win98,WinOther,Win2000,WinXP,WinServer

Query Plan has the following requirements :

.NET Framework 1.1

TAGS OF QUERY PLAN

plants vs zomies , planet earth , errorplane pc error repair , rational plan , plane games , plane screensaver , aeroplane agent software , fast plans