Re: shared_pool_size is 0 bytes in v$parameter

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 28 Apr 2004 03:24:34 GMT
Message-ID: <StFjc.126225$e17.80851@twister.nyroc.rr.com>

"sarab" <sarabjeetd_at_hotmail.com> wrote in message news:08gjc.437$5s1.97_at_news.cpqcorp.net...
> Hi ,
> i have a Oracle 10g database on hpux 11i. The value of
> shared_pool_size in V$parameter is 0 bytes.
> Cam somebody explain why is it so?.
>
> regards
> -sarab
>
>

From the reference doc, the default for shared_pool_size: If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool. If SGA_TARGET is not set (32-bit platforms): 32 MB, rounded up to the nearest granule size

If SGA_TARGET is not set (64-bit platforms): 84 MB, rounded up to the nearest granule size

Anurag Received on Tue Apr 27 2004 - 22:24:34 CDT