RE: SGA greater than 4 Gbytes.

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Thu, 12 Oct 2000 10:46:15 -0700
Message-Id: <10647.119092@fatcity.com>

here it is on popular demand

hth
deepAk

PS: any u guys still have that thread on sending mulitiple files as attachments from unix command line .. tia

Creating Large SGA

Changing the 'sgabeg' in 'ksms.o' will allow increasing SGA size and allocating the memory in a contiguous segment. For RDBMS version 8.1.x, change the attach address by doing the = following
steps to relocate the SGA:

Shutdown any databases using the current "ORACLE_HOME".
Change the location to the "/lib" directory
$ cd $ORACLE_HOME/lib
Make a backup copy of 'libserver8.a'.
$ cp libserver8.a libserver8.a.orig
Change your location to the "rdbms/lib" directory
$ cd $ORACLE_HOME/rdbms/lib
Generate the "ksms.s" file
$ $ORACLE_HOME/bin/genksms -b <new_location> > ksms.s
$ $ORACLE_HOME/bin/genksms -b 0x60000000 >ksms.s=20
Where 0x60000000 is the new attach address (refer to the table below = for the correct attach address)
Regenerate the 'ksms.o' object:
$ make -f ins_rdbms.mk ksms.o
Archive 'ksms.o' into 'libserver8.a'
$ ar r $ORACLE_HOME/lib/libserver8.a ksms.o
Relink
$ make -f ins_rdbms.mk ioracle

Large SGA size values
To configure the SGA to a value greater than 256 Mbytes on Sun system = refer
to the following sgabeg parameter chart:

Sgabeg Address	SGA Size
0xe0000000	256Mb
0xd0000000	512Mb
0xc0000000	768Mb
0xb0000000	1Gb
0xa0000000	1.25Gb
0x90000000	1.5Gb
0x80000000	1.75Gb
0x77000000	just less than 2Gb SGA
0x70000000	2Gb
0x60000000	2.25Gb
0x50000000	2.5Gb
0x40000000	2.75Gb
0x30000000	3Gb
0x20000000	3.25Gb
0x10000000	3.5Gb
0x01000000	16Mb less than 3.75Gb SGA

Note: 	Whenever Oracle release upgrade patch is installed the ksms.o =

will
have to be regenerated with the appropriate attach address to create a = large
SGA. -----Original Message-----
From: Joseph on Mediaone [mailto:josepha_at_mediaone.net] Sent: Wednesday, October 11, 2000 7:27 PM To: DThapliyal_at_ea.com
Subject: Re: SGA greater than 4 Gbytes.

Hi, Deepak:
I read your message with great interest. We are on 8.0.4 now and are going to move to 8.1.6 or 7. Our SGA = currently
is 90 MB out of 1 GB total available. We want to use transition moment = to
rearrange SGA. If you can e-mail material how to choose parameters I = would
appreciate it very much. I have read somewhere that about1/3 of all available RAM should be dedicated to SGA. Thank you for help.
Joseph Abramson.
P.S. It would be nice if youcould respond to jabramso_at_1tac.com as well. JA

-----Original Message-----
From: Thapliyal, Deepak <DThapliyal_at_ea.com> To: Multiple recipients of list ORACLE-L < > Date: Wednesday, October 11, 2000 7:18 PM Subject: RE: SGA greater than 4 Gbytes.

hi Miguel

u need to reset the starting address of the SGA and recreate some = freakin
k*.o objects and finally relink the oracle binaries. if all this does = not
make sense and sounds weird to you and even then u are still intrested = in
step by step details of the same.. please reply to me and i will = forward you
the doc i picked up off of ML for configuring large sga's under 32 bit = OS as
is the case for u. i am not even aware if there is a init parameter to enable this execpt the regular dbbuffer/sharedpool and logbuff = parameters

hth
deepak
-----Original Message-----
Sent: Wednesday, October 11, 2000 11:01 AM To: Multiple recipients of list ORACLE-L

Yes, you should defintly increase the SHMMAX parameter so Oracle can = get one
single shared memory segment for the SGA.

Richard Ji

-----Original Message-----
Urosa Ruiz
Sent: Wednesday, October 11, 2000 5:35 AM To: Multiple recipients of list ORACLE-L

Hi folks.

We=B4re working with Oracle 8.1.5 over SunOS 5.6 and want to create = an SGA
greater than 4 Gbytes. I know I have to use USE_INDIRECT_DATA_BUFFERS = =3D TRUE
but I'd like to know if I have to set another parameter in = init<SID>.ora or
/etc/system, like SHMMAX.

Any idea would we appreciate.

Thank you very much in advance.

Regards.

Miguel.

________________________________________________________________________=

_
Get Your Private, Free E-mail from MSN Hotmail at = http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miguel Urosa Ruiz
  INET: miguelurosa_ruiz_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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
  INET: richard_at_letsplay.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: Thapliyal, Deepak
  INET: DThapliyal_at_ea.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

Received on Thu Oct 12 2000 - 12:46:15 CDT