| DBMS Stats gathering [message #480755] |
Tue, 26 October 2010 18:49  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
Oracle 10g has the feature of automatic stats gathering in this case is it necessary to run DBMS_STATS on tables manually.
Does the stats gathered become stale when the auto stat runs ?
|
|
|
|
| Re: DBMS Stats gathering [message #480756 is a reply to message #480755] |
Tue, 26 October 2010 18:56  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>is it necessary to run DBMS_STATS on tables manually.
no, not necessary.
by default the job runs once every 24 hours.
When you see LAST_ANALYZED being days, weeks, or months in the past do not be alarmed.
If/when the data in a table does not change, then the statistics do not need to change.
Oracle collects new statistics when enough of the data (about 10%) has changed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
