HP-UX 11 kernel tuning for multiple Oracle8 SIDs

[Scott Robertson]

Anyone have some suggestions or documents pertaining to this subject?

Some background, as this is a new sysadmin experience for me. Instead of one server providing application and database services, our new hardware environment will provide for database and application servers to be separate physical servers. This in turn will cause several production databases to be running on one server. I'm looking for some "been there, done that" tuning information or any relevant documents.

[Victor BERRIDGE]

Something like # ps -ef|grep pmon|more
dbap24h 7553 1 0 Jun 8 ? 16:21 ora_pmon_P24H
dbaprda 18695 1 2 22:16:45 ? 0:08 ora_pmon_PRDA
dbapsac 26545 1 0 23:38:57 ? 0:07 ora_pmon_PSAC
dbapcar 28581 1 2 23:49:52 ? 0:07 ora_pmon_PCAR
dbapsad 3991 1 2 20:18:10 ? 0:10 ora_pmon_PSAD
root 10298 10407 1 17:54:27 ttyp1 0:00 grep pmon
dbaprde 17243 1 2 22:06:58 ? 0:08 ora_pmon_PRDE
dbapsyn 10859 1 0 21:09:33 ? 0:09 ora_pmon_PSYN
?

One instance owner per instance
separate listener per instance

Good luck

Victor

[Alexander M. Ermes]

Hi there.
Victor is a genius. But be careful, if you use a 32-bit HP-UX 11.00, because if you do not run memory windows on your machine, the to?tal
size of the SGA's should not exceed 1.75 GB.
So take care.
Rgds
Alexander M. Ermes

[Rhonda Thorne · Accepted solution]

Hi..

For each instance, the oracle SGA is a shared memory seg. so make sure that your kernel params for shared memory are large enough to hold total size of all SGA's added together.

maxdsize
nproc
maxusers
These should be verified with oracle's requirments

Good luck

[Scott Robertson]

Victor,
I just wish the DBA's here would use one owner per instance, they prefer one owner and listener for all instances. Some logic just scrambles the mind.

Alexander,
Thanks for you input, and our servers will be 64-bit HP and 64-bit Oracle, so the SGA 1.75GB limitation should not be an issue. N4000's will be handling our new software environment.

Rhonda,
Thanks for you input, and I will keep this information handy, for when the fun begins.

[Victor BERRIDGE]

there was a reason behind the multiple uids, when it comes to semaphores and having to ipcrm etc...when all is under a same uid you need nerves...

Good luck
Victor

[CHRIS ANORUO]

Look at the following attached document

[CHRIS ANORUO]

There was no way I could post 2 attachements: Look a this second document

[Scott Robertson]

Victor,
Excellent thought and a great point for ease of admin. I'll have to run your multiple uids idea passed the senior DBA's and get their thoughts.

Chris,
Thanks for the documents. I'll be passing these onto the DBA staff for awareness.