From mark@cool-tools.co.uk Wed, 06 Jun 2001 03:07:15 -0700 From: "Mark Leith" Date: Wed, 06 Jun 2001 03:07:15 -0700 Subject: RE: contents of SGA Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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" >>Reply-To: ORACLE-L@fatcity.com >>To: Multiple recipients of list ORACLE-L >>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@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@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@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@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@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@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@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@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).