topic Re: shared-memory segment size limit in Operating System - HP-UX

shared-memory segment size limit

Amit Kureel — Mon, 18 Sep 2000 12:02:50 GMT

I want to configure the SGA for my Oracle database greater than 1 GB, but configuring a larger size generates an error in Oracle error, I have read somewhere in HP-UX documentation that we can't configure a shared-memory segment size greater than 1 GB in a straightforward manner for the applications, can anybody help me ?

Re: shared-memory segment size limit

James R. Ferguson — Mon, 18 Sep 2000 12:07:39 GMT

Hi:

Hi:

See if the followig documents help:

#S3100001006 & #RCMEMKBAN00000027

http://www.docs.hp.com/hpux/content/KCparams.OverviewAll.html

...JRF...

Re: shared-memory segment size limit

Alex Glennie — Mon, 18 Sep 2000 12:08:22 GMT

The maximum size for a single shared memory segment on a 32 bit
operating system is 1 GB. We can't change that limit, therefore
we can't change shmmax.

Applications linked (compiled) with Shared Magic can use 2.75 GB
total virtual memory space. Shared Magic changes the way a system
uses the four quadrants of shared memory space.

Re: shared-memory segment size limit

John Palmer — Mon, 18 Sep 2000 12:13:37 GMT

1Gb is the limit for a single shared memory segment in 32 bit mode.

Recent versions of Oracle are available in both 32bit and 64bit.

Are you able to run 64bit HP-UX 11.00 with a 64bit Oracle? This gives an SGA limit of 1 Terabyte!

Re: shared-memory segment size limit

Kofi ARTHIABAH — Mon, 18 Sep 2000 12:21:53 GMT

Amit:

You do not mention which versions of OS and oracle you are running... but to get you started, look at the following threads:

http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0x5694c3d7fb78d4118fef0090279cd0f9,00.html
http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xf69e0559ff7cd4118fef0090279cd0f9,00.html
http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0x595968c57f64d4118fee0090279cd0f9,00.html

BTW you might be able to find even more information by searching for Oracle SGA in the forums and technical documents.

Re: shared-memory segment size limit

Amit Kureel — Wed, 20 Sep 2000 08:46:49 GMT

Thanks to all of you, may be I got the answer, My Oracle is 7.3.4 and is 32-bit, I think that is where lies the limitation.

Thanks again
Amit Kureel

Re: shared-memory segment size limit

Amit Kureel — Wed, 20 Sep 2000 08:52:13 GMT

Thanks to all of you, may be I got the answer, My Oracle is 7.3.4 and is 32-bit, I think that is where lies the limitation.

Thanks again
Amit Kureel