contents of SGA

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Tue, 05 Jun 2001 04:10:33 -0700
Message-ID: <F001.0031BAEE.20010605040108@fatcity.com>

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). Received on Tue Jun 05 2001 - 06:10:33 CDT