Operating System - HP-UX
1748266 Members
3527 Online
108760 Solutions
New Discussion юеВ

Re: two database on a single server

 
arun m govind
Frequent Advisor

two database on a single server

hi

I am using True 64 Unix 5.1 OS. When i am using two database on this server both database comes down very slow. Single database is working fine, But when i create second database then this problem occurs
server configuration is
1.5 GB RAM
Dual processor
70 GB HDD

Database Details
ONE
database size 8 GB
SGA size 300 MB
Second
database size 12 GB
SGA size 300 MB

What could be the reason????
7 REPLIES 7
Lethuillier
Frequent Advisor

Re: two database on a single server

Shortage of resources.

If you can, try to install more RAM.
Il faut avoir la foi et non les foies - Il faut avoir la forme et non les formes - Il faut faire la paix et non des pets
arun m govind
Frequent Advisor

Re: two database on a single server

thanks for your reply
How much RAM should be increased.????

I think something is wrong with shared memory kernel parameters also. Can you please tell me the configuration for the same scenerio.
Yogeeraj_1
Honored Contributor

Re: two database on a single server

hi,

before taking any further action, can you please post the output of the following command:

kmtune |grep shmmax


kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
arun m govind
Frequent Advisor

Re: two database on a single server

please let me know
what should be the value of shmmax and other kernel parameters according to the scenerio.

thanks
Lethuillier
Frequent Advisor

Re: two database on a single server

PAVIC Thierry
Frequent Advisor

Re: two database on a single server

Try this analyse method :
put on a shell file :
LANG=fr_FR.iso88591;
export LANG;
date
fic=/tmp/SAR_`date '+%Y%m%d' `
echo $fic
sar -o $fic 60 1440 > /dev/null

This command put in a file something like a day of sar out put
After analyse the result .


Other way : check the swap

because a new database take memory and increase i/o demands.

for the memory : SGA + X Mb by each connection.

Regards Thierry
Hein van den Heuvel
Honored Contributor

Re: two database on a single server

>>> I am using True 64 Unix 5.1 OS.

Then you may want to re-post in the Tru64 forum, or some Oracle forumm, for better exposure.

Which Oracle version? May we assume 10g?

Did you follow the Tru64 pre-installation tasks? I guess not, otherwise you would not ask for shm_max advice: it's all in the doc!

"Oracle├В┬о Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide
10g Release 2 (10.2) for hp Tru64
Part Number B14206-01"

http://download-east.oracle.com/docs/cd/B19306_01/install.102/b14206/pretru.htm#sthref435

For advanced tuning see:

http://download-east.oracle.com/docs/html/A97297_01/appd_tru.htm

What is 'very slow'? Seconds or Minutes?
With users or just up and down again?
What is happening when it is comming down?
Disk IO? Nothing? CPU time? system CPU time?
If it is (system) CPU times, then I'd recommend a quick 'kprofile' or 'dcpi' run to see where the system is spending time.

I recall cases of slow Oracle rundown in older versions of Tru64 (called OSF back then!) with large numbers of users. GH memory was designed to solved that.

If the it is CPU busy, then I suspect a shared memory issue and woulc doublecheck settings for GH (sysconfig -q vm | grep gh) and ssm_threshold

Good luck!
Hein.