Re: short of memory ?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 24 Apr 2004 14:47:43 GMT
Message-ID: <j6vic.15414$eK3.8650@nwrdny01.gnilink.net>

"zeb" <spam_at_nowhere.com> wrote in message 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:

--snip--
> *.db_block_size=8192
> *.db_cache_size=16777216

--snip--
> *.java_pool_size=33554432

--snip--
> *.large_pool_size=8388608

--snip--
> *.pga_aggregate_target=16777216

--snip--
> *.shared_pool_size=33554432
> *.sort_area_size=524288

--snip--
> *.user_dump_dest='/tools/oracle/9.2.0/admin/DB9IDEV/udump'

Apart from what others have said, I do not see you setting worksize_area_policy=auto .. for your pga_aggregate_target to come into effect.

Anurag Received on Sat Apr 24 2004 - 09:47:43 CDT