Gather query tuning data via Oracle's dynamic performance views

Wednesday Sep 10th 2008 by DatabaseJournal.com Staff

The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS.

[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

Mobile Site | Full Site