Home » RDBMS Server » Server Administration » how to get process information.
how to get process information. [message #553383] Fri, 04 May 2012 02:26 Go to next message
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.
Re: how to get process information. [message #553384 is a reply to message #553383] Fri, 04 May 2012 02:32 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: how to get process information. [message #553390 is a reply to message #553387] Fri, 04 May 2012 03:41 Go to previous message
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
Previous Topic: upgrade oracle 11.2.0.1 to 11.2.0.2
Next Topic: system tablespace had been used more.
Goto Forum:
  


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