Re: strange issue with java_pool

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Thu, 18 Mar 2004 15:34:04 -0500
Message-ID: <20040318203404.GA3531@mladen.wangtrading.com>

On 03/18/2004 02:34:55 PM, DENNIS WILLIAMS wrote:
> Srinivas
> Look up granule size in the Oracle9i Concepts manual.

Granule size is determined by total SGA size. On most platforms, the size of a granule is 4 MB if the total SGA size is less than 128 MB, and it is 16 MB for larger SGAs. There may be some platform dependency, for example, on 32-bit Windows NT, the granule size is 8 MB for SGAs larger than 128 MB.

I was right. It is allocated in 16MB increments. When you specify 50MB, you'll be allocated 64MB. Try specifying 53MB.

>
>
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
> Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech)
> Sent: Thursday, March 18, 2004 11:44 AM
> To: oracle-l_at_freelists.org
> Subject: strange issue with java_pool_size
>
>
>
> Hi All,
>
>
>
> OS: solaris 2.8
>
> DB: 9i (9.2.0.3)
>
>
>
> When we set java_pool_size to 50M (52428800) in init.ora and bounce the db,
> it is showing the value as 64M (67108864).
>
>
>
> Can somebody throough some light on this ?
>
>
>
> Has anyone encountered this situation ? (any other parameters effecting this
> ?)
>
>
>
> Thanks and Regards,
>
> Srinivas
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 18 2004 - 15:13:43 CST

Re: strange issue with java_pool_size