OraFAQ Forum: Server Administration » how to get process information.

Home » RDBMS Server » Server Administration » how to get process information.

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

how to get process information. [message #553383]

Fri, 04 May 2012 02:26

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

hello experts,
is there any view in oracle for getting the total number of processes and currently used process in oracle? i am using oracle 11.2.0.1.0.

thanx in advance.

Report message to a moderator

Re: how to get process information. [message #553384 is a reply to message #553383]

Fri, 04 May 2012 02:32

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
You can get the info from v$process.

[Updated on: Fri, 04 May 2012 02:41]

Report message to a moderator

Re: how to get process information. [message #553387 is a reply to message #553384]

Fri, 04 May 2012 02:52

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks for response,
but it is not helpfull. it is not giving process info about my user.

thanks again.

Report message to a moderator

Re: how to get process information. [message #553390 is a reply to message #553387]

Fri, 04 May 2012 03:41

Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which process info? And which user?
V$PROCESSS gives you the info about the Oracle processes.
Join it with V$SESSION if you want some information about the user and the session.

All catalog views are described in Database Reference.

Regards
Michel

Report message to a moderator

Previous Topic:	upgrade oracle 11.2.0.1 to 11.2.0.2
Next Topic:	system tablespace had been used more.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 14 18:17:49 CDT 2021