you are confusing the size of the SGA (System Global Area) which is 40M with
the size of the shared pool, which you set to 10M
The shared pool is contained within the SGA, but is NOT the only component
of the SGA. Also, depending on the version of Oracle you are running there
may be default values associated with structures like the java pool which
will add to the size of the SGA.
Rachel
>From: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: contents of SGA
>Date: Tue, 05 Jun 2001 04:01:08 -0800
>
>One of my co-worker came with this ques. In the init.ora file he had set
>the shared_pool_size to 10M and db_block_buffers=1024 and redolog buffer to
>32768. but when he did sho sga in the sql*plus prompt he got the following
>output
>
>Total System Global Area 41297948 bytes
>Fixed Size 75804 bytes
>Variable Size 32755712 bytes
>Database Buffers 8388608 bytes
>Redo Buffers 77824 bytes
>
>Doing a select on V$SGA also gave the same result.
>
>My shared pool size is only 10M, why it is showing nearly 40M. From where
>did oracle derive the extra MB's? I ran throu the oracle manual and got
>only answer for database buffers.
>
>Can any one tell from where these extra MB's come to Oracle from the OS.
>
>TIA
>
>Venkat
>
>
>Get 250 color business cards for FREE!
>http://businesscards.lycos.com/vp/fastpath/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: C.S.Venkata Subramanian
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
