| Gathering Schema Stats [message #193515] |
Mon, 18 September 2006 01:33  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
I have an error in my db alert file
Performance statistics empty: data overflow
I conclude that it is due to statistics are not available so we have to gahter statistics periodicaly but i am afraid that when we analyze table then perhaps information about these analyzed these tables cached in database buffer cache bocome invalid then is that true? that these object reloads will occur
is that true? that performance degrades
|
|
|
|
|
|
|
|
| Re: Gathering Schema Stats [message #193530 is a reply to message #193524] |
Mon, 18 September 2006 02:35  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
yes i am usisng 8i server
using CBO and optimizer_mode=choose
if we use CBO then we should gather statistics periodically
although we have optimizer_mode=choose if the statistics does not exist then oracle will use rule based optimizer
but i just want to confirm what the reason for the error
data overflow:performance statistics empty
i also want to confirm that if i analyze objects(tables,indexes) periodically then is it true? that cached information in shared_pool become invalid so that these objects needed to be reload again so that is there any performance degradation?
Perhaps this will be understandable for you
|
|
|
|
| Re: Gathering Schema Stats [message #193591 is a reply to message #193530] |
Mon, 18 September 2006 06:56 |
kimant
Messages: 201
Registered: August 2006
Location: Denmark
|
Senior Member |
|
|
Hi
First of all, begin analyzing using the dbms_stats package instead. You will need to use this in 9i and 10g anyway.
Second, I do not think there are any connection between the bug and the shared pool (at least not as You think there is).
The bug states that the message should be ignored.
Br
Kim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
