Re: uptime
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 13 Sep 2012 12:28:12 -0300
Message-ID: <CAJ2dSGQ6BDn-0Ejb3wxMeFjsP2Y-sY5S+YsYDuNGpSgg2ePkAQ_at_mail.gmail.com>
We had one sun server with a single database with about 726 days of uptime. Obviously nobody ever patched anything there :-P. About windows server, the only servers I ever asked to be rebooted weekly were a 9i RAC on windows 2000... and every time they rebooted performance picked up about 20%. It was only for a few weeks until we migrated it to a 10.2 RAC on Linux, though.
If you are on at least 10.2.0.5 and on windows 2008, I don't think you need to reboot that frequently, maybe just once a month or fortnight for patching purposes. Also, if you see a performance benefit to rebooting, then maybe you have an oversized SGA (probably an oversized shared pool).
Date: Thu, 13 Sep 2012 12:28:12 -0300
Message-ID: <CAJ2dSGQ6BDn-0Ejb3wxMeFjsP2Y-sY5S+YsYDuNGpSgg2ePkAQ_at_mail.gmail.com>
We had one sun server with a single database with about 726 days of uptime. Obviously nobody ever patched anything there :-P. About windows server, the only servers I ever asked to be rebooted weekly were a 9i RAC on windows 2000... and every time they rebooted performance picked up about 20%. It was only for a few weeks until we migrated it to a 10.2 RAC on Linux, though.
If you are on at least 10.2.0.5 and on windows 2008, I don't think you need to reboot that frequently, maybe just once a month or fortnight for patching purposes. Also, if you see a performance benefit to rebooting, then maybe you have an oversized SGA (probably an oversized shared pool).
cheers
Alan.-
On Thu, Sep 13, 2012 at 12:02 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
> What Oracle version? Are there not some memory leak bugs in some Oracle
> versions? 9.2.0.3 on some Unix versions for one has memory leaks that
> require DB restarts as I recall.
> <SNIP>
> >
> >
> >
> > http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 13 2012 - 10:28:12 CDT