Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need advice on ORA-04030 and pga_aggregate_target parameter

Re: Need advice on ORA-04030 and pga_aggregate_target parameter

From: Ronny <nitelyjoy_at_ist-einmalig.de>
Date: 14 May 2007 14:51:01 -0700
Message-ID: <1179179461.122583.282210@e65g2000hsc.googlegroups.com>


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 - 16:51:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US