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 FinkHelp 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 -- //www.freelists.org/webpage/oracle-l