Hello,
Does anybody know of any memory leaks with Oracle 9i for AIX 5.1?

We have Oracle 9.2.0.4.0 Enterprise Edition running on AIX 5.1, and have
noticed that Oracle gradually consumes a large amount of memory (there is 2
GB real and 2 GB virtual), although the net activity (automated) & sessions
remains constant. In a few days, the machine freezes when the paging space
reaches 95%. Shutting down Oracle will release 80% of the paging space.

Thanks

Ralph Fernan wrote:
> Hello,
> Does anybody know of any memory leaks with Oracle 9i for AIX 5.1?
>
> We have Oracle 9.2.0.4.0 Enterprise Edition running on AIX 5.1, and
have
> noticed that Oracle gradually consumes a large amount of memory
(there is 2
> GB real and 2 GB virtual), although the net activity (automated) &
sessions
> remains constant. In a few days, the machine freezes when the paging
space
> reaches 95%. Shutting down Oracle will release 80% of the paging
space.

I have experiences only with 5.2, but maybe even with them I can help
you. Look at the setup of in-memory caching of disk operations. As
default there is an enormous big number, 20% or something like that.
This space is then filled as the Oracle makes more and more disk
writes, in your case it could be 400MB or even more. It is not
displayed in nmon64 or similar tools it just eat the space.
After checking of this look at the patch #3028673. It decreases an
amount of memory occupied by each server process. This one is only for
5.2, but maybe there is a similar one also for 5.1. The improvement by
this is tremendous, another up to 20% of memory freed is possible.

--
Dusan Bolek
http://www.db-support.com

Email: spambin@seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email will face an
unpleasant end as SPAM.

"Ralph Fernan" <ralphfernan@N0SPAM.com> wrote in message
news:kgtrd.1013039$Gx4.311267@bgtnsc04-news.ops.worldnet.att.net...
> Hello,
> Does anybody know of any memory leaks with Oracle 9i for AIX 5.1?
>
> We have Oracle 9.2.0.4.0 Enterprise Edition running on AIX 5.1, and have
> noticed that Oracle gradually consumes a large amount of memory (there is
2
> GB real and 2 GB virtual), although the net activity (automated) &
sessions
> remains constant. In a few days, the machine freezes when the paging
space
> reaches 95%. Shutting down Oracle will release 80% of the paging space.
>
> Thanks
>

I believe patchset 9.2.0.5 is available for AIX so you might try upgrading
your db first to fix any bugs.

Matthias