Re: Reboot your server regularly to gain better performance

"JustAnotherDBA" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message news:<WEJwa.23838$cg.2215_at_fe10.atl2.webusenet.com>...
> It's interesting to me to note that there is even a market for a tool to
> replace the one you that comes with the windows OS. AND, the fact that this
> tool is advertised for reboot usage is even more interesting :)
>
> A quote from the web page ... "Even you have 1GB RAM in your Windows server.
> After few days, you will see your available physical memory become smaller
> and smaller from the Task Manager"
>

funny thing about oracle on win32 - the memory doesn't get "committed or charged" until the instance actually throws it. so as your "% free memory" in v$sgastat decreases and the number of user processes (threads) increases, the amount of memory in use by the oracle.exe process(es) will increase. This is not due to a leak (normally, provided that you did not use the 8.1.7.4.10 patchset with cursor_sharing = FORCE - in which case the ORA-600 [729] will populate your event log and the \udump folder) but due to the fact that sessions are allocating memory, and the shared pool is claming memory that was allocated for it.

a larger warm cache is far better than a cold, smaller cache, unless you have all garbage in your shared pool. In that case, you might as well flush it all away ...

flush L. Ron Hubbard and flush all his clones flush all you junkies and flush your short memories flush all you coders that refuse to use bind variables  learn to swim.

Maynard

>
> --
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3ec24306$0$19598$ed9e5944_at_reading.news.pipex.net...
> > "JustAnotherDBA" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message
> > news:fCjwa.41620$hu.25793_at_fe03.atl2.webusenet.com...
> > > Consider a real operating system (Unix/Linux) that doesn't require
> reboots
> > > and doesn't require 3rd party utilities to do something like scheduling
> > > (crontab).
> >
> > windows doesn't require 3rd party utilities for scheduling either.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> >
> >
Received on Tue May 20 2003 - 00:36:47 CDT