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
> 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