Re: User count at a point in time

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 21 Aug 2009 11:06:42 -0700
Message-ID: <bf46380908211106r1beb69c7y50f96a32b93c27c5_at_mail.gmail.com>

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_at_gmail.com> 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
>
>
>

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

Received on Fri Aug 21 2009 - 13:06:42 CDT