Oracle performance problem

[Lovro VRES]

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

[Duncan Edmonstone]

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

[Lovro VRES]

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

[Duncan Edmonstone · Accepted solution]

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

[Lovro VRES]

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

[Lovro VRES]

Closed.