Re: User count at a point in time
- From: Jared Still <jkstill@xxxxxxxxx>
- To: fuadar@xxxxxxxxx
- Date: Fri, 21 Aug 2009 11:06:42 -0700
It looks like that bit of SQL is out of date, as the timestamps
don't seem to contain the actual logon time.
You may still want to look at the audit view, as that would
be a simple method to accomplish this
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Fri, Aug 21, 2009 at 11:01 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
> 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:
