This is scary,
I'm planning to upgrade 9.2.0.4 from 9.2.0.2.
I don't know how
removing pga_aggegrate_target will help reducing
memory!!
Does the program
have any memory tables, etc?
Did you monitor
the PGA size from the Oracle side using v$sesstat?
A sql by itself
can't consume this
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set workarea_size_policy=manual;
Jared
On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote:
Hi,
I have an ora-4030 problem related to pga memory
PROTECTED]
Verzonden: dinsdag 23 december 2003 18:34
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: ora-4030 pga memory allocation running wild
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set