Thanks, From where does these default values come?? Is there any file or table or
Oracle default.
--
On Tue, 05 Jun 2001 05:36:51
Rachel Carmichael wrote:
>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).
>
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).
