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: SGA and PGA

Re: SGA and PGA

From: astalavista <nobody_at_nowhere.com>
Date: Sat, 28 Oct 2006 16:19:32 +0200
Message-ID: <454366ee$0$3878$426a74cc@news.free.fr>

> 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

Original text of this message

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