Gather query tuning data via Oracle's dynamic performance views

September 10, 2008

[From Builder AU]

For several releases now, DBAs and developers have had access to three dynamic performance views -- V$SQL, V$SQLAREA, and V$SQLTEXT -- that can be used to collect statistics about the performance of their SQL statements. In Oracle 10g, Release 2, a fourth dynamic performance view -- V$SQLSTATS -- has been added that is a more convenient way to access this data.

The article continues at http://www.builderau.com.au/program/oracle/soa/Gather-query-tuning-data-via-Oracle-s-dynamic-performance-views/0,339028441,339291791,00.htm