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: 15 May 2007 11:52:12 -0700
Message-ID: <1179255132.751590.312470@h2g2000hsg.googlegroups.com>


> Why would you say that? The Oracle rule is 40% of RAM.
>
> The largest recommended would be 1.6GB.

Example for OLTP systems: "... leaving 80% for the SGA." http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i47856 Received on Tue May 15 2007 - 13:52:12 CDT

Original text of this message

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