OraFAQ Forum: Server Administration » Table Statistics for oracle 11g

Home » RDBMS Server » Server Administration » Table Statistics for oracle 11g (oracle 11g R1, Linux x86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table Statistics for oracle 11g [message #569387]

Thu, 25 October 2012 08:30

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

Report message to a moderator

Re: Table Statistics for oracle 11g [message #569388 is a reply to message #569387]

Thu, 25 October 2012 08:38

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Table Statistics for oracle 11g [message #569389 is a reply to message #569387]

Thu, 25 October 2012 08:42

John Watson
Messages: 8962
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.

Report message to a moderator

Previous Topic:	nls_length_semantics = 'CHAR', acts like 'BYTE'
Next Topic:	ORA-01113: file 1 needs media recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:55:33 CST 2025