Must have Software for 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...
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...
