Number of database processes per user

  • From: John Dunn <JDunn@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Jun 2015 09:09:27 +0000


I know how to get the total number of data processes running via :
select resource_name, current_utilization, max_utilization from
v$resource_limit where resource_name in ('processes','sessions');

But how can I find out how many processes are running for a particular database
user(schema)?


John Dunn

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2015