Fw: 'shared pool'

 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: <ORACLE-L_at_fatcity.com> 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" <mladen_at_wangtrading.com>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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 TYPE VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > shared_pool_reserved_size big integer 10905190
> > shared_pool_size big integer 218103808
> > SQL> select 251658240-218103808 from dual;
> >
> > 251658240-218103808
> > -------------------
> > 33554432
> >
> > SQL> show parameter db_cache_size
> >
> > NAME TYPE VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > db_cache_size big integer 419430400
> > SQL>
> >
> > On Tue, 2003-10-07 at 17:54, bulbultyagi_at_now-india.net.in 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: mladen_at_wangtrading.com
> >
> > 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: ListGuru_at_fatcity.com (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
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

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: ListGuru_at_fatcity.com (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).