Operating System - HP-UX
1748046 Members
4858 Online
108757 Solutions
New Discussion юеВ

Re: Oracle 9i installation on hpux 11.

 
SOLVED
Go to solution
Yogeeraj_1
Honored Contributor

Re: Oracle 9i installation on hpux 11.

hi Jorg,

i think your SGA is not properly sized.

I would recommend you to edit your configuration file and use the settings for a small database. (configuration file is $ORACLE_HOME/dbs/init.ora)

To start with the main parameters that you should look into are:
large_pool_size, shared_pool_size and java_pool_size

Are you using MTS or Dedicated?
Dedicated processes take more memory.

are you using java?
If not, you can use a lower value for your JAVA_POOL_SIZE

Most Important of all: Check you OS setting as per the pre-installation tasks. If you did not go through it before the installatio, go through it again.

Hope this helps.
Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
T G Manikandan
Honored Contributor

Re: Oracle 9i installation on hpux 11.

Hello,
The SGA is per instance.
check your SGA size.

go to server manager
$svrmgrl
svrmgrl>connect internal
svrmgrl>show sga
to find the size of the database.

Thanks
Giel Smits
Occasional Advisor

Re: Oracle 9i installation on hpux 11.

Thanx guys..
I think I have the appropriate information..

I'll check the above suggestions..
Bill Hassell
Honored Contributor

Re: Oracle 9i installation on hpux 11.

Just a note about RAM and Oracle. 512 megs is crippling Oracle. Think a minimum of 2 Gbytes, (4 Gbytes is much better) so that SGA can be increased to a useful value without massive swapping. You can verify swapping with vmstat. If the "po" column is more than 1 digit for long periods (minutes) then your system is swapping and performance will be awful (more than 100 and people will have problems logging in).

The fact that it takes 3 days to create a new database seems to confirm that RAM is way too small.


Bill Hassell, sysadmin