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

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: 10677
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: 7027
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: SYS Invalid Objects
Goto Forum:

Current Time: Sat Aug 19 15:43:29 CDT 2017

Total time taken to generate the page: 0.05469 seconds