Re: Oracle 8 and memory on NT --reboot?

On Sun, 10 Jan 1999 20:45:05 -0800, David Spaisman <davedba_at_intercall.com> wrote:

>ello :
>
>I have noticed that NT server does not easily
>release memory and periodically the server needs to
>be shutdown to recoup the memory.
>
>My questions are :
>
>1) To shutdown the NT server, either manually or ny
>batch, do I always need to stop the two oracle
>services first? Is not, will the database crash?
>

Yup, I periodically also have to shutdown. And, no I don't shutdown the services. I just let the shutdown procedure shut them down - cleanly I presume..........

>Is there anyway to to gracefully shutdown the
>instance on NT if the server needs to be rebooted
>without manually stoppping the Oracle services?
>

Go into server manager and do a shutdown I suppose. I never do, but I don't know of NT is just doing a crash and burn, or if Oracle is smart enough to shut down politely BEFORE NT shuts down.

>2) How often do I nned to have the NT server
>rebooted? Although I realize this is
>application-specific, has anyone experienced the
>need to reboot the server periodically ? How often?
>Any problems with Oracle or any other applications
>being able to start?

I run developer from a standalone NT box. I have to reboot frequently 'cause REPORTS appears to EAT memory.... At least daily. If I'm working on a martrix of significance, I can watch the thing start climbing and in a few hours I've used all 128MB of real memory and often 80 - 90 mb of virtual. And this is when I'm only using 6MB for the database memory... I've used the task manager to watch the memory usage climb as I make changes and run the report...

When things get slow I reboot..... Shutting down the Report designer does not give the memory back. Shutting down ANYTHING doesn't appear to give it back. I haven't tried shutting down the database, but nothing else appears to help. Forms appears to do the same thing, but they're usually smaller so its not as big a problem.

I'd love it if someone could tell me how to get Oracle to give the memory back WITHOUT having to reboot........ Received on Sun Jan 10 1999 - 21:08:18 CST