Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: short of memory ?
"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 ?
Are you sure each connection is using this amount? See http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=174555.1
jg
-- @home.com is bogus. http://news.netcraft.com/archives/2004/04/21/secret_repairs_preceded_tcp_flaw_release.htmlReceived on Fri Apr 23 2004 - 19:10:33 CDT