Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need advice on ORA-04030 and pga_aggregate_target parameter
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
![]() |
![]() |