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: ORA-04030: out of process memory

Re: ORA-04030: out of process memory

From: AK <ak_at_ak.org>
Date: Fri, 13 Aug 2004 04:46:02 GMT
Message-ID: <eIXSc.311$aA.12991@news.optus.net.au> 





>>So on both counts, I see that my 24MB PGA_AGGREGATE_TARGET needs to be
>>increased.  I can double or treble it - the v$pga_target_advice doesnt
>>really indicate to me what to set it to.




> 

> 

> Don't trust too much to the advisors...

> 




I take it you mean to suggest the same as your other post - use 
v$sesstat and v$sysstat to see how the app behaves with current memory 
settings...and increase/decrease accordingly?



-A
Received on Thu Aug 12 2004 - 23:46:02 CDT












Original text of this message













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