Number of database processes per user

From: John Dunn <JDunn_at_sefas.com>
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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 25 2015 - 11:09:27 CEST

Original text of this message