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>
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-lReceived on Thu Jun 25 2015 - 11:09:27 CEST