|
|
Select Fast!
by Priodata
Priodata Select Fast! automates repetitive tasks associated with the SQL tuning process on the Oracle Database. You can easily keep track of all alternative queries you create, run them simultaneously to collect statistics, run EXPLAIN PLAN, capture plan from V$SQL_PLAN, set bind variables and initialization parameters, etc. Better yet, you can save all this information in a single file to share. Also has an interface to Oracle''s Tuning Advisor.
oracle sql tuning tools shareware explain plan statistics advisor
|
|
|
Query Plan
by Priodata
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). All this with a fine graphical interface, without having to write your own queries and joins.
oracle tuning sql cursors library cache v$sql v$sql_plan v$sqltext
|
