Gather query tuning data via Oracle’s dynamic performance views

(Bob Watkins) 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—

Read More - Register for Free Membership