Re: User count at a point in time
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Fri, 21 Aug 2009 11:23:06 -0700 (PDT)
So from a debugging standpoint it is something we have to create and not
something already enabled or collected right . Just making sure that my
assumption here is the correct one .
I'm trying to debug an issue that happened in the past and while is see oracle
is collect history of v$resource_limit i cant find any clear way to correlate
the v$resource_limit data to actual logons at a point in time.
________________________________
From: Jared Still <jkstill@xxxxxxxxx>
To: fuadar@xxxxxxxxx
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, August 21, 2009 1:01:38 PM
Subject: Re: User count at a point in time
On Fri, Aug 21, 2009 at 10:31 AM, Fuad Arshad <fuadar@xxxxxxxxx> 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
Other related posts:
