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: 64956
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: How to judge the slow query?
Next Topic: Performance of database runnig on RAC 10g with two Solaris nodes
Goto Forum:

Current Time: Tue Jun 27 00:36:13 CDT 2017

Total time taken to generate the page: 0.12400 seconds