Home » RDBMS Server » Performance Tuning » stale_stats and STATTYPE_LOCKED in DBA_TAB_STATISTICS
stale_stats and STATTYPE_LOCKED in DBA_TAB_STATISTICS [message #406646] Fri, 05 June 2009 03:01 Go to next message
casttree
Messages: 83
Registered: August 2008
Member
I hope to upderstand more for the column stale_stats and STATTYPE_LOCKED in table DBA_TAB_STATISTICS.

from http://www.praetoriate.com/data_dictionary/dd_dba_tab_statistics.htm

The description as

STATTYPE_LOCKED
Description of DBA_TAB_STATISTICS.STATTYPE_LOCKED: "type of statistics lock"
STALE_STATS
Description of DBA_TAB_STATISTICS.STALE_STATS: "Whether statistics for the object is stale or not"


based on what condition we can decide the object is stale or not?

also if the object statistics is locked, the object status can't be missed?


In EM , from database "Server" tab, "Manage Optimizer
Statistics" "Object Statistics" , looks object status are listed as "Analyzed" "Missing" "lock" "stale" , what are relationship for these status?

Thanks,


[Updated on: Fri, 05 June 2009 03:07]

Report message to a moderator

Re: how to decide the stale_stats in DBA_TAB_STATISTICS [message #406649 is a reply to message #406646] Fri, 05 June 2009 03:10 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 14 Managing Optimizer Statistics
Section 14.2 Automatic Statistics Gathering
Section 14.3 Manual Statistics Gathering
Paragraph 14.3.1.5 Determining Stale Statistics

Regards
Michel

[Updated on: Fri, 05 June 2009 03:10]

Report message to a moderator

Previous Topic: How to judge the slow query?
Next Topic: Performance of database runnig on RAC 10g with two Solaris nodes
Goto Forum:
  


Current Time: Sat Dec 10 05:05:01 CST 2016

Total time taken to generate the page: 0.10774 seconds