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 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, [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 -- Author: <[EMAIL PROTECTED] 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).