Query Plan
Query Plan

Software Categories

Query Plan 1.1


Query Plan general info

Query Plan A tool to browse Oracle's library cache to locate SQL statement to tune. Shows the execution plan in the classical hierarquical view, shows complete SQL text (without having to write complex joins to V$SQLTEXT). Compatible with Oracle 9i and later.
PriodataDeveloper :
1.1Version :
Windows 98/ME/NT/2000/XP Platform :
0.2 MbFile Size :
Free to try; $42 to buy License :
April 17, 2006 Date Added :
Free download Query PlanDownload :
Query Plan screenshotScreenshot :
Keywords : oracle, tuning, sql, cursors, library, cache, v$sql, v$sql_plan, v$sqltext

Query Plan Full Description

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. Compatible with Oracle 9i and later.

Software related to Query Plan

  • Database Architect 2.0
    Define database tables, fields, references, and generate the database

    Visustin 7
    Visustin converts source code to flow charts and UML activity diagrams.

    NCache 3.2
    Speed up .NET Apps with Clustered Object Cache and ASP.NET Sessions.

    Foxy SQL Pro 1.1
    Run SQL queries and commands on any database. Connections: ADO, ODBC and native.

    CASE Studio 2 v 2.23.1
    Create ER diagrams for various databases, generate SQL scripts, HTML reports...

    Foxy SQL Free 1.1
    Run SQL queries and commands on any database. Connections: ADO, ODBC and native.

    Currency Server 5.5.5.0
    Advanced currency information and conversions for COM/ActiveX/.NET/SOAP/Web

    Rpv Business Reports 5.2
    Create reports from any programming language and any operating system

    EazyDoc 2.0.1
    Documents in MS-Word - the structure of MS-SQL 2000 & 2005 databases

    Resource-Grabber 2.68d
    Extract thousands of glyphs/images/sounds from other programs!

Software AwardQuery Plan Rating: