Gather query tuning data via Oracle's dynamic performance views

Wednesday Sep 10th 2008 by DatabaseJournal.com Staff
Share:

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved