Re: DBMS_STATS.GATHER_SYSTEM_STATS samples only BADSTATS

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 13 Dec 2005 22:34:30 +0100
Message-ID: <01a901c6002d$0344d9d0$2308310a@IBME1D11967173>

> It looks like you may be getting a lot of
> data from a file-system buffer. (Or possibly your system
> has been up for so long that you are getting an odd
> 32-bit wrap on some counters).

Thanks!
This is a 24h production system and it's restarted quite seldom.

xxxxxx$ uptime
10:30pm up 692 day(s), 6:27, 1 user, load average: 0.18, 0.20, 0.20

Last database restart at:

Thu Mar 17 10:51:10 2005
Starting ORACLE instance (normal)

Most probably I'll have the possibility to check this after the next system crash :O).

Best regards,
Dimitre Radoulov

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 13 2005 - 15:35:50 CST