Home » RDBMS Server » Backup & Recovery » Gathering Schema Stats
Gathering Schema Stats [message #193515] Mon, 18 September 2006 01:33 Go to next message
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 #193523 is a reply to message #193515] Mon, 18 September 2006 02:06 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
What are the lines above and below that line in the alert log?
Re: Gathering Schema Stats [message #193524 is a reply to message #193515] Mon, 18 September 2006 02:09 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
I guess You are using Oracle 8.1.x and MTS?

It it most likely bug 1246206.
- And the message can be ignored.

Br
Kim Anthonisen
Re: Gathering Schema Stats [message #193530 is a reply to message #193524] Mon, 18 September 2006 02:35 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: ORa-01135
Next Topic: Multiplexing of files
Goto Forum:
  


Current Time: Mon Dec 05 07:02:19 CST 2016

Total time taken to generate the page: 0.05318 seconds