RE: contents of SGA

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 06 Jun 2001 03:07:15 -0700
Message-ID: <F001.0031D956.20010606014117@fatcity.com>

The defaults are in the initSID.ora file, which is the initialization file that Oracle reads upon startup.

If you are running Oracle 8 > then you cna usually find this file in ORACLE_HOME/admin/SID/pfile

Open the file and look for the parameter JAVA_POOL_SIZE and change as necessary, and then bounce the instance..

HTH Mark

-----Original Message-----
Subramanian
Sent: Wednesday, June 06, 2001 06:15
To: Multiple recipients of list ORACLE-L

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

>

>_________________________________________________________________

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

>



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: Mark Leith
  INET: mark_at_cool-tools.co.uk

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 Wed Jun 06 2001 - 05:07:15 CDT