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)
On May 14, 5:51 pm, Ronny <nitely..._at_ist-einmalig.de> wrote:
> Your problem is not PGA, but SGA:
> For ORA-04030, increase your large_pool and java_pool_size.
>
> 1.2 GB SGA seems quite small for 4 GB RAM.
>
> For your system, you should start with a RAM config like this:
> 2.5 GB for SGA ("Automatic Shared Memory Management" should work fine
> with 10gR2. Please read the docs.)
> 0.7 GB for PGA
> 0.8 GB for OS
>
> After that you can start fine tuning (if needed at all).
>
> Regards,
> NitelyJoy
Received on Mon May 14 2007 - 20:37:00 CDT
