RE: Oracle 9i 365-day reboot issue

Walt,

First...HAPPY BIRTHDAY! I'll buy you a beer if I ever make it to Bozeman :)

Second, this may be a case of one issue being carried over to another. I recall that certain Unix systems (HP-UX?) required a periodic bounce because some of the Oracle memory structures/counters were not large enough to handle the numbers that would be generated over time. I have not had to deal with this issue in quite a while, so it may have been a 32 bit issue as well.

I did a search on metalink and came up with nothing.

Regards,
Dan

--

Daniel Fink

Help me support The Children's Hospital of Denver! I'm riding in the 2008 Courage Classic - 157 miles in 3 days Help me reach my goal of $2,500.00 in donations. Visit my Personal Rider Page http://www.couragetours.com/2008/danielwfink to donate

OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training

OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com

Lost Data? http://www.ora600.be/

• Original Message ------- On 8/8/2008 3:00 PM Walt Weaver wrote: Hello all,Some of the older list members may remember me; I've been more or less away from Oracle for a few years but we still have a few old 9i systems I still maintain on a sporadic basis. Anyway, one of our few remaining Oracle customers recently requested that we bounce the Oracle instance they were on; they said there was a bug in 9i that required the instance be bounced at least every 365 days. Does anyone know anything about this? I haven't been able to find out anything about it; my Metalink account expired a long time ago and Googling hasn't turned up anything.Any information will be greatly appreciated. Thanks,--Walt Weaver, old Oracle fart (it's my 60th birthday today) -- Bozeman, Montana
  --
  http://www.freelists.org/webpage/oracle-l