Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SGA and PGA
> I would suggest setting reasonable defaults, make sure db_cache_advice
> = on and use the advisors to adjust.
> 2500M is likely unnecessary, or you must be working exclusively with
> untuned SQL. Even in that case such a value wouldn't help. Shared pool
> = typically 250M java pool = 150M buffer cache = 512M usually
> sufficient.
> Large pool is only used for shared server and RMAN.
Is java_pool required if you don't use java in the database ? Received on Sat Oct 28 2006 - 09:19:32 CDT