It's because of the SGA_MAX_SIZE parameter, which is, of course, rounded
so that the SGA can be aligned to the page boundary.
On Wed, 2003-10-08 at 19:59, [EMAIL PROTECTED] wrote:
> Mladen ,is all this
> documented anywhere or is it all very common knowledge ? I can't believe
> that all you expert dbas would let Oracle take away tens of mbs of memory
> without
> telling you.
>
> - Original Message -
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 09, 2003 04:11
>
>
> > Mladen , thanks for replying . Please tell me why does one get a
> difference
> > between the values returned from v$sgastat and the shared pool size set
> in
> > the parameter file ?
> > Please , explain this to me . Arup explained that the memory required to
> > manage the buffer
> > cache is also allocated from the shared pool. Is there any ratio or does
> > this mean that if I allocate x MB to my buffer cache, Oracle
> > allocates that x mb for the buffer cache , and an additional x mb or 32
> mb
> > for
> > managing the buffer cache and places it in the shared pool ?
> >
> >
> >
> > - Original Message -
> > From: "Mladen Gogala" <[EMAIL PROTECTED]>
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 08, 2003 03:49
> > Subject: Re: 'shared pool'
> >
> >
> > >
> > > Not so on my instance.
> > >
> > > SQL> select sum(bytes) from v$sgastat
> > > 2 where pool='shared pool';
> > >
> > > SUM(BYTES)
> > > --
> > > 251658240
> > >
> > > SQL> show parameter shared_pool
> > >
> > > NAME TYPEVALUE
> > > ---
> > > --
> > > shared_pool_reserved_sizebig integer 10905190
> > > shared_pool_size big integer 218103808
> > > SQL> select 251658240-218103808 from dual;
> > >
> > > 251658240-218103808
> > > ---
> > >33554432
> > >
> > > SQL> show parameter db_cache_size
> > >
> > > NAME TYPEVALUE
> > > ---
> > > --
> > > db_cache_sizebig integer 419430400
> > > SQL>
> > >
> > > On Tue, 2003-10-07 at 17:54, [EMAIL PROTECTED] wrote:
> > > > List please try out the following :
> > > > 1. select sum(bytes) from v$sgastat where pool='shared pool';
> > > >
> > > > 2. find out the size of the shared pool you have specified in your
> > > > parameter files.
> > > >
> > > > 3. subtract the two values
> > > >
> > > > 4. When I do the same as above the difference is exactly equal to my
> > > > db_cache_size.
> > > >
> > > > So does this mean that if I allocate x MB to my buffer cache, Oracle
> > > > allocates that x mb for the buffer cache , and an additional x mb for
> > > > managing the buffer cache and places it in the shared pool ?
> > > >
> > > > Please explain this to me.
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > >
> > >
> > >
> > >
> > > Note:
> > > This message is for the named person's use only. It may contain
> > confidential, proprietary or legally privileged information. No
> > confidentiality or privilege is waived or lost by any mistransmission. If
> > you receive this message in error, please immediately delete it and all
> > copies of it from your system, destroy any hard copies of it and notify
> the
> > sender. You must not, directly or indirectly, use, disclose, distribute,
> > print, or copy any part of this message if you are not the intended
> > recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> > right to monitor all e-mail communications through its networks.
> > > Any views expressed in this message are those of the individual sender,
> > except where the message states otherwise and the sender is authorized to
> > state them to be the views of any such entity.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Mladen Gogala
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No co