Home » RDBMS Server » Server Administration » Table Statistics for oracle 11g (oracle 11g R1, Linux x86_64)
Table Statistics for oracle 11g [message #569387] Thu, 25 October 2012 08:30 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi All,

I want to get the stale stats for Table resides at APPS schema.
Is there is any table or view exists to get the details like DBA_STALE_STATS or anything?
Currently I am checking LAST_ANALYZED column from DBA_TABLES?

Thanks-
P
Re: Table Statistics for oracle 11g [message #569388 is a reply to message #569387] Thu, 25 October 2012 08:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I believe you are looking find the tables with stale stats.
You can use the option "LIST STALE" along dbms_stats.
Re: Table Statistics for oracle 11g [message #569389 is a reply to message #569387] Thu, 25 October 2012 08:42 Go to previous message
John Watson
Messages: 4577
Registered: January 2010
Location: Global Village
Senior Member
Stale statistics are identified by comparing the DML activity tracked in dba_tab_modifications with the statistics currently known. If you look at dba_tab_modifications and think "those figures are rubbish", that could be because they aren't updated in real-time: execute dbms_stats.flush_database_monitoring_info to force an update.
Previous Topic: nls_length_semantics = 'CHAR', acts like 'BYTE'
Next Topic: ORA-01113: file 1 needs media recovery
Goto Forum:
  


Current Time: Tue Sep 23 00:10:13 CDT 2014

Total time taken to generate the page: 0.11926 seconds