topic Re: Oracle performance problem in Operating System - HP-UX

Oracle performance problem

Lovro VRES — Fri, 05 Jun 2009 05:17:18 GMT

Hello,

I have two different instances of Oracle running on my HP-UX 11.31.
I would like to findout, how many processor time is used by first instance and how many time is used by second instance.

I would like to get the sum of all ORCL processes ans sum for all ORCL2 processes in desired time.

Both instances are running under username oracle.

Is there any idea how can I do this?

Regards,
Lovro

Re: Oracle performance problem

Duncan Edmonstone — Fri, 05 Jun 2009 05:48:35 GMT

Lovro,

Do you have glance on your system? if so its pretty easy to do this using application groups...

otherwise I think you're down to doing something with ps like:

UNIX95= ps -eo args,pcpu | grep -E -e [o]ra_...._${ORACLE_SID} -e [o]racle${ORACLE_SID}

which if you have ORACLE_SID set to one of your oracle instance IDs, should print the current % CPU usage for each process.

HTH

Duncan

Re: Oracle performance problem

Lovro VRES — Fri, 05 Jun 2009 09:06:05 GMT

Hello,

I have GlancePlus, but I still don't know how to create two different oracle application for two different Oracle_SID. Owner for both instances is oracle.

Regadrs,
Lovro

Re: Oracle performance problem

Duncan Edmonstone — Fri, 05 Jun 2009 09:48:29 GMT

Lovro,

Group processes in Glance is really easy... lets suppose I have two oracle instances called BLUE and GREEN just edit the file /var/opt/perf/parm - got to the bottom of the file and you will find the lines:

application = other_user_root
user = root

Now add some lines *above* this entry as follows:

application = oracle_GREEN
file = ora*GREEN
application = oracle_BLUE
file = ora*BLUE

save the file and you might also need to start the performance agent by executing:

ovpa restart all

then fire up glance with the -A option

glance -A

You should see your 2 databases listed together with CPU/IO/Mem metrics

HTH

Duncan

Re: Oracle performance problem

Lovro VRES — Fri, 05 Jun 2009 09:53:03 GMT

Hello,

thank you for your answer. In mean time I managed to solve the problem. I did exactly as yous said and it works fine. I have a mistake in my previous parm file, so I didn't saw what I want.
Thank you again.

regards,
Lovro

Re: Oracle performance problem

Lovro VRES — Fri, 05 Jun 2009 09:53:32 GMT

Closed.