Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 10g hangs the system when assigning 10Gb of RAM

SOLVED
Go to solution
moonchild
Regular Advisor

Oracle 10g hangs the system when assigning 10Gb of RAM

Hi

HPUX 11.11 with 80G of RAM

when we start the Oracle 10g instance with SGA set to 4G it runs fine. when we set it to 10GB the system hangs/locks and we're obliged to TOC it.

Thanks
9 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

Shalom,

Clearly an Oracle issue. Check with metalink for fixes or maximum SGA settings.

I have heard of this behavior before, you may be exceeding the design specifications of 10g

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
skt_skt
Honored Contributor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

check if the 10g need a higher value set for shmmax. We had iincrased the value when we upgraded to 10g with HP-UX 11.23.
Yogeeraj_1
Honored Contributor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

hi,

What are parameters that you have changed?

Since you are on oracle 10g, you may wish to read more about SGA_TARGET initialisation parameter and how it affects the SGA.


hope this helps!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

hi again,

Assuming you have already configured the required parameters at the OS level, configuring the Oracle database is rather "simple". For memory considerations, you must look at SGA - System Global Area, which as in Oracle 10g can be summarised as below:


When an Oracle instance is started, memory is allocated for the SGA based on the values specified in the initialisation parameter file or hard-coded in the Oracle software. Many of the parameters that control the size of the various parts of the SGA are dynamic. Normally if the parameter SGA_MAX_SIZE is specified, the total size of the all SGA areas must not exceed the value of SGA_MAX_SIZE. If the SGA_MAX_SIZE is not specified, but the SGA_TARGET is specified, Oracle automatically adjusts the sizes of the SGA components so that the total amount of memory allocated is equal to SGA_TARGET. SGA_TARGET is a dynamic parameter; it can be changed while the instance is running.


hope this helps too!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

Hi,

If you use Oracle Automatic Shared Memory Management it is very important that STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL. Please check these settings (default is TYPICAL)

Regards,
Vadim
Eric Antunes
Honored Contributor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

Hi,

What is your patchset level?

What value do you have for shmmax?

Anything in the alert.log file??

Best Regards,

Eric Antunes


Each and every day is a good day to learn.
Sani
Frequent Advisor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

Hi

1)Are you using the combination of hpux 11.11 and oracle 10g ???? !!!!.
Have you installed required os patches in hpux 11.11 before the installation of 10g?.

3)If you are using async io for oracle then change the minor no of /dev/async to 0x000100 and try ..
moonchild
Regular Advisor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

Hi

We had to replace the memory extender board.

thank you all for your help and support
moonchild
Regular Advisor

Re: Oracle 10g hangs the system when assigning 10Gb of RAM

please see above