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 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]