| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: contents of SGA
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" <csvenkata_at_lycos.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: csvenkata_at_lycos.com
>
>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: 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.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com 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: 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).Received on Tue Jun 05 2001 - 08:07:04 CDT
 |
 |