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.
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-lReceived on Fri Aug 21 2009 - 13:06:42 CDT