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
Is the above calculation implying the use of MTS or you forgot to
factor in the memory for Oracle shaddow process(es)?
Received on Tue May 15 2007 - 14:29:48 CDT
