Collect object stats [message #594509] |
Thu, 29 August 2013 06:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/15c82c7d9fc8aa37529ca79b866d6993?s=64&d=mm&r=g) |
suhasdba
Messages: 141 Registered: April 2013 Location: INDIA
|
Senior Member |
|
|
Hi,
Quote:Oracle collects new statistics when enough of the data (about 10%) has changed.
I read the above statement in the oracle documentation that Oracle collects new statistics when
enough of the data (about 10%) has changed every day during 10 pm to 6am .
But still i see some object statistics are stale and empty.Do i need to collect statistics for these objects manually ?
and would like to know why these objects statistics were not collected during maintenance window ?
Thanks
|
|
|
|
|
|
|