Re: used up memory

From: <yong321_at_yahoo.com>
Date: 20 Jul 2006 07:37:00 -0700
Message-ID: <1153406220.341814.14630@i42g2000cwa.googlegroups.com>

BL wrote:
> Hi all,
>
> I have a Sun server with 8GB memory and running 4 instance.
> 1st instance with sga 700MB
> 2nd instance with sga 500MB
> 3rd instance with sga 300MB
> 4th instance with sga 100MB
>
> When all instances are started up, there are no problems and the web
> users can use the database through the web application. However, when
> the server is running the batch job, the server's memory can't be
> released. I am new in oracle. Is it oracle's configuration problem? If
> not, how can I prove it?
>
> Thanks,
> Brian

It helps if you tell us the version of Oracle. If you use 9i (or above) and auto workarea_size_policy, the PGA part of a server process's memory can be released back to OS. If this version or configuration is not possible to you, try always using the same database session to do the batch job.

Yong Huang Received on Thu Jul 20 2006 - 09:37:00 CDT