Re: DBMS_STATS.GATHER_SYSTEM_STATS samples only BADSTATS

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: <jonathan@xxxxxxxxxxxxxxxxxx>
  • Date: Tue, 13 Dec 2005 22:34:30 +0100

 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

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


Other related posts: