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
Messages: 83
Registered: August 2008
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

Description of DBA_TAB_STATISTICS.STATTYPE_LOCKED: "type of statistics lock"
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?


[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: 65153
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 Determining Stale Statistics


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

Report message to a moderator

Previous Topic: very simple but very slow query
Next Topic: How to tune memory size in oracle 8i (merged)
Goto Forum:

Current Time: Tue Aug 22 17:52:25 CDT 2017

Total time taken to generate the page: 0.08141 seconds