Number of database processes per user

From: John Dunn <>
Date: Thu, 25 Jun 2015 09:09:27 +0000
Message-ID: <EEC3316514CFB24AB2285394E0D405587C8867A3_at_BOU.sefasuk.local>

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

Received on Thu Jun 25 2015 - 11:09:27 CEST

Original text of this message