topic Re: Oracle Processess in Operating System - HP-UX

Oracle Processess

Rafael Mendonça Braga — Thu, 29 Sep 2005 07:45:02 GMT

Hello experts!!!

I'm with a problem and don't know from where to start.

I'm using HpUX 11i as OS, and Oracle (8i and 9i) as database.
I have some of the instances as 8i and others as 9i. Looking the server's performance with glance or top command I always get oracle processes like these:

oracledbslade1
oracledbslapr1
oracledbdwhprd

oracle is fixed and following it we have the name of the instance.
If I have more than one aplication running on one of these instances, for example, Aplication A and Aplication B running on dbslade1 when I use top or glance, I can't see wich aplication is overloading the system. I see the process oracledbslade1 running but I don't know wich aplication is inside it...

Is there a way to know what aplication is running associated to that process without the needing of use Oracle tools? Cause if I pass the PID of the process to the DBAs, They can identify it, but I want to identify it on the OS.

Do you know something about it??

Thanks in advance!

Rafael M. Braga

Re: Oracle Processess

Raj D. — Thu, 29 Sep 2005 07:52:58 GMT

Hi Rafael ,

Try using tnsping , to check the database performance and response.

Here it is :

http://www.oracleutilities.com/OSUtil/ping.html

Cheers,
Raj.

Re: Oracle Processess

Alessandro Pilati — Thu, 29 Sep 2005 07:54:19 GMT

Hi Rafael,
check this utility, it may be useful:

http://www.front-row-seat.com/articles/oracle_top_cpu.html

Good luck!
Alessandro

Re: Oracle Processess

baiju_3 — Thu, 29 Sep 2005 07:58:44 GMT

Hi ,

On Unix as you mentioned we can identify the process with the suffixed SIDs. But for getting the details what is that process about ,you may need to take help from your DBAs.I doubt there is any Unix tool to assit you in that .

Thanks,
BL.