Re: short of memory ?

From: G Dahler <yellow-shark_at_spamex.com>
Date: Fri, 23 Apr 2004 16:00:11 -0400
Message-ID: <iBeic.39720$CO3.1335374@news20.bellglobal.com>

"zeb" <spam_at_nowhere.com> a écrit dans le message de news:40881965$0$17595$636a15ce_at_news.free.fr...
>
> Hi,
>
> (oracle 9.2.0.1 HP-UX 11.0)
>
> I have the following problem
> each connection => server process 68 MB
> so my memory is quickly full
> How can I reduce this amount ?
> pga_aggregate_target ?
>
> Thanks
>
> Here my SPFILE:

> *.java_pool_size=33554432

You can set java pool size to 1 Mb instead of 32 Mb if you did not enable the JVM (Or after you have dropped it) At least you can do this on 8i, maybe you HAVE to install the JVM in 9i+.

Other than that, beware that what on most UNIX platforms, the ps command SIZE column usually includes the shared memory segment that is mapped to your SGA. If you have an SGA of 64 Mb for example, and you process really uses 4 Mb of memory, it seems to use 68 Mb.

As a matter of fact, you might discover that if you add the reported size of ALL your oracle shadow processes, you'll probably en up with a lot more memory used than your physical mem + swap space total ! Received on Fri Apr 23 2004 - 15:00:11 CDT