cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle performance problem

 
SOLVED
Go to solution
Lovro VRES
Advisor

Oracle performance problem

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
5 REPLIES

Re: Oracle performance problem

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


HTH

Duncan
Lovro VRES
Advisor

Re: Oracle performance problem

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
Solution

Re: Oracle performance problem

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


HTH

Duncan
Lovro VRES
Advisor

Re: Oracle performance problem

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
Advisor

Re: Oracle performance problem

Closed.