Re: logon users report

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Apr 2005 09:58:40 -0700
Message-ID: <1112720320.805512.176760@l41g2000cwc.googlegroups.com>

Facun Chamut wrote:
> Hi,
> I am trying to find information regarding users loging on to our
Oracle
> 9i DB. Stuff like when was the last time they log on, how much time
> they spent online, etc. On which table(s) would I find this
> information?
> Thanks,
>
> -Facundo.

You have to switch on session auditing to get this information.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/audit.htm#10617

and look for "Auditing Connections and Disconnections". You can view the audit info. in sys.aud$.

Regards
/Rauf Received on Tue Apr 05 2005 - 11:58:40 CDT