topic Re: two database on a single server in Operating System - HP-UX

two database on a single server

arun m govind — Mon, 28 Aug 2006 04:58:59 GMT

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????

Re: two database on a single server

Lethuillier — Tue, 29 Aug 2006 01:32:27 GMT

Shortage of resources.

If you can, try to install more RAM.

Re: two database on a single server

arun m govind — Tue, 29 Aug 2006 01:49:47 GMT

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.

Re: two database on a single server

Yogeeraj_1 — Tue, 29 Aug 2006 02:03:21 GMT

hi,

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

kmtune |grep shmmax

kind regards
yogeeraj

Re: two database on a single server

arun m govind — Thu, 31 Aug 2006 06:41:17 GMT

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

thanks

Re: two database on a single server

Lethuillier — Thu, 31 Aug 2006 09:01:36 GMT

Take a look here for kernel parameters :

http://docs.hp.com/en/939/KCParms/KCparams.OverviewAll.html

and there for semaphore parameters :

http://docs.hp.com/en/939/KCParms/KCparam.SemaphoreParamsList.html
http://www.dbforums.com/t497029.html
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=504530
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=607147

Re: two database on a single server

PAVIC Thierry — Mon, 04 Sep 2006 08:16:50 GMT

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

Re: two database on a single server

Hein van den Heuvel — Mon, 04 Sep 2006 10:07:40 GMT

>>> 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.