Re: User count at a point in time

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 21 Aug 2009 11:01:38 -0700
Message-ID: <bf46380908211101s2e111e5t25d127e2504ce83a_at_mail.gmail.com>

On Fri, Aug 21, 2009 at 10:31 AM, Fuad Arshad <fuadar_at_yahoo.com> wrote:

> List
> I'm trying to figure out someone that potientially can be basic
> I know awr and ash contain data about users that were connected I'm trying
> to find a way to tell at a point in time how many users were connected
> I.e abc had 500 sessions
> Def has 600 sessions
> Basically looking to match the users the caused my process resource limit
> to exceed .this is more of debugging exercise
>

You can do that with auditing by enabling session auditing.

select

   username

   ,timestamp logon
   ,logoff_time logoff
   , os_username
   ,terminal
   ,action_name
   ,returncode

from dba_audit_session
order by timestamp
/

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Fri Aug 21 2009 - 13:01:38 CDT