Re: Bouncing Serving

On May 29, 8:25 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> We have an off-site database (10g R2, Win2003 Server) that gets bounced
> twice a week on a schedule.
>
> The reason I was told is that our "vendor" (the people taking care of it)
> recommended it to "flush junk".
>
> Is there any real reason to bounce a server twice a week to clear memory (or
> anything else for that matter) that could/should be handled by having the
> database actually configured properly?

I am running Oracle 10.2.0.2 on 64 bit Windows. Bouncing an Oracle database on Windows twice a year might be reasonable, twice a month points to a problem, but twice a week points to a severe administration problem. You might want to check the value for CURSOR_SHARING. When set to FORCE (and possibly SIMILAR), it might be necssary to bounce an Oracle 10.2.0.2 database instance with any patch applied a couple times a week, or even as often as every couple hours - this is not a Windows only problem.

Try to obtain a better explanation of the problem. Flush junk may mean many things (hope that they do not mean flushing a twice weekly cold backup to tape).

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Tue May 29 2007 - 20:05:53 CDT