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: Performance Issue

Re: Performance Issue

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Mon, 04 Dec 2006 10:30:02 +0100
Message-ID: <4573e9b1$0$6751$426a74cc@news.free.fr>


Charles Hooper wrote:
> Jerome Vitalis wrote:

>> Charles Hooper wrote:
>>
>>> starting point.  If you do not expect to use Java, set the Java Pool to
>>> a small value, such as 1MB.
>> Just out of curiosity: any reason why you wouldn't set it to 0 in this case?

>
> As I recall, 1MB was the recommended value for the java_pool_size in
> "Oracle Performance Tuning 101" by Gaja Krishna Vaidyanatha, if Java is
> not in use. You may also find other authors making that suggestion:
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2969177070991
>
> Note that in 10g, the effective granule size can actually set the
> java_pool_size to 16MB, even if it is specified as 1MB in the init.ora
> or spfile.
>
> Was it a limitation in some versions of Oracle that the java_pool_size
> had to be 1MB at a minimum, or was this recommendation just protection
> against the rogue developer who suddenly finds that Oracle supports
> Java? The answer is likely out there, somewhere.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
>

Thanks a lot Charles for taking the time to reply with these useful details.

Jerome Received on Mon Dec 04 2006 - 03:30:02 CST

Original text of this message

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