RE: Oracle 9i 365-day reboot issue

From: Daniel W. Fink <>
Date: Fri, 8 Aug 2008 10:51:39 -0500
Message-ID: <>


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.



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 to donate - Oracle Performance, Diagnosis, Data Recovery and Training

Oracle Blog

Lost Data?

  • 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
Received on Fri Aug 08 2008 - 10:51:39 CDT

Original text of this message