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).
