Re: Number of database processes per user

From: Sreejith Nair <sreejithsna_at_gmail.com>
Date: Fri, 26 Jun 2015 23:46:56 +0530
Message-ID: <CALPgMHuaAZ95sB6-FdqWC-bHxAMzC6CosuckHCv0aA01vhBPJw_at_mail.gmail.com>

You can write a query to check v$session with group by v$session.username would give you server processes per user. You can also account background processes which are not running for particular 'users'.

On Thursday, June 25, 2015, John Dunn <JDunn_at_sefas.com> wrote:

>
>
> 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*
>

-- 
Regards
Sreejith

Sent from my iPhone

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 26 2015 - 20:16:56 CEST