Sunday, November 17, 2013
Change your monitoring script to use v$sqlstats
"The column definitions for columns in V$SQLSTATS are identical to those in the V$SQL and V$SQLAREA views. However, the V$SQLSTATS view differs from V$SQL and V$SQLAREA in that it is faster, more scalable, and has a greater data retention (the statistics may still appear in this view, even after the cursor has been aged out of the shared pool)."
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment