Re: Need advice on ORA-04030 and pga_aggregate_target parameter

On 15 Mai, 03:37, harvinde..._at_gmail.com wrote:
> All the listings searched points to PGA for this error, it will be
> great if you can send me some link that can show how this error can
> happen due to incorrect size of SGA (normally we get ora-04031 for SGA
> sizing errors)

OK, you are right, sorry. ORA-04030 points to PGA, not SGA.

Metalink Note:233869.1 seems to be useful here. Obviously, OS limits are too restrictive in our case (as Mladen Gogala mentioned, too).

Regards,
NitelyJoy Received on Tue May 15 2007 - 13:44:30 CDT