OraFAQ Forum: Server Administration » back track os processes to rdbms

Home » RDBMS Server » Server Administration » back track os processes to rdbms (RHEL 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

back track os processes to rdbms [message #583845]

Sun, 05 May 2013 16:56

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

Report message to a moderator

Re: back track os processes to rdbms [message #583852 is a reply to message #583845]

Mon, 06 May 2013 00:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: back track os processes to rdbms [message #584636 is a reply to message #583852]

Thu, 16 May 2013 08:12

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

Report message to a moderator

Re: back track os processes to rdbms [message #584641 is a reply to message #584636]

Thu, 16 May 2013 08:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: back track os processes to rdbms [message #584645 is a reply to message #584641]

Thu, 16 May 2013 09:05

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:39:25 CST 2024