V$sql_plan Software

Query Plan by Priodata

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.

oracle tuning sql cursors library cache v$sql v$sql_plan v$sqltext

Select Fast! by Priodata

A tool to automate repetitive tasks associated with the SQL tuning process on the Oracle Database. Run query to get statistics, run EXPLAIN PLAN, capture plan from V$SQL_PLAN, set bind variables, etc. Also has an interface to Oracle''s Tuning Advisor

oracle sql tuning tools shareware explain plan statistics advisor