| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SGA greater than 4 Gbytes.
Hi,
On Sequent/IBM NUMA, the use_indirect_data_buffers is the init parameter
that enables the addressing a shared memory segment that is greater than
the 4G limit for a 32 bit OS. The relocation of the SGA needs to be done if
you cannot accomadate the buffers in the available address locations.
Hope this helps.
Regards,
Madhavan
>From: "Thapliyal, Deepak" <DThapliyal_at_ea.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: SGA greater than 4 Gbytes.
>Date: Wed, 11 Oct 2000 15:30:35 -0800
>
>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´re 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 =
>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
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |