RE: 10g - System Statistics - Quick Q

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Fri, 23 Jan 2009 16:06:46 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6F29B_at_ADMINMAIL1.ui.uillinois.edu>

Thanks, I don't mean table/index stats though, only the system statistics, ie those gathered by ' execute dbms_stats.gather_system_stats('Start');'

-----Original Message-----

From: Sweetser, Joe [mailto:JSweetser_at_icat.com] Sent: Friday, January 23, 2009 4:08 PM
To: Newman, Christopher; oracle-l_at_freelists.org Subject: RE: 10g - System Statistics - Quick Q

Not sure if this will help but I believe there is a last_analyzed column in dba_tables that might be of use. Can't check right now but I think that's the name.

Hth,
-joe

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher Sent: Friday, January 23, 2009 2:55 PM
To: oracle-l_at_freelists.org
Subject: 10g - System Statistics - Quick Q

Anyone know how to determine when system statistics were gathered? IE, the last time?

Thanks! - Chris

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 23 2009 - 16:06:46 CST