Query Plan

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