shared-memory segment size limit

[Amit Kureel]

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 ?

[James R. Ferguson]

Hi:

Hi:

See if the followig documents help:

#S3100001006 & #RCMEMKBAN00000027

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

...JRF...

[Alex Glennie]

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.

[John Palmer]

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!

[Kofi ARTHIABAH]

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.

[Amit Kureel]

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

[Amit Kureel]

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