Home » RDBMS Server » Server Administration » back track os processes to rdbms (RHEL 5.5)
back track os processes to rdbms [message #583845] Sun, 05 May 2013 16:56 Go to next message
sbk785
Messages: 5
Registered: May 2013
Junior Member
hello ..

I have two Oracle databases (test1- 10gr2,test2 - 11gr2) on rhel 5.5. is it possible to find which particular oracle process belongs to which home from OS level. was trying to find which db processes are consuming more resources on my host. checked top but cudnt find luck. can someone help me here please ..

thanks in advance
Re: back track os processes to rdbms [message #583852 is a reply to message #583845] Mon, 06 May 2013 00:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The name of the processes at OS level contains the name of the instance, so you can just use ps and grep.

Regards
Michel
Re: back track os processes to rdbms [message #584636 is a reply to message #583852] Thu, 16 May 2013 08:12 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Hi,

Please check spid in V$process view in both database, if OS process ID same as spid then that process belong to that instance.
select spid from v$process;


Regards,
Anil
Re: back track os processes to rdbms [message #584641 is a reply to message #584636] Thu, 16 May 2013 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Note that the question is: " is it possible to find which particular oracle process belongs to which home from OS level."
Also note that I already answered to the question.
Please carefully read the questions and answers BEFORE posting yours.

Regards
Michel
Re: back track os processes to rdbms [message #584645 is a reply to message #584641] Thu, 16 May 2013 09:05 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear Michel,

Your message was well noted,My point is to share things i learn,But i have to read question fully

Thanks&Regards,
Anil

Previous Topic: Oracle8i Service did not start
Next Topic: ORA-03114 error while creating DB using DBCA
Goto Forum:
  


Current Time: Thu Oct 02 08:05:30 CDT 2014

Total time taken to generate the page: 0.06455 seconds