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.

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.