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: <harvinder76_at_gmail.com>
Date: 14 May 2007 18:37:00 -0700
Message-ID: <1179193020.870511.164480@k79g2000hse.googlegroups.com>


 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

Original text of this message

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