Re: logon users report

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 05 Apr 2005 18:50:34 +0200
Message-ID: <3cg551hkecme7r7k7pd5c9qrhcavl8b1p1@4ax.com>

On 5 Apr 2005 08:26:08 -0700, "Facun Chamut" <facunchamut_at_gmail.com> 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.

dba_audit_session. However this information is not stored by default. You'll need to enable auditing by setting the audit_trail parameter to db and you''ll need to issue audit connect to get it running.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Apr 05 2005 - 11:50:34 CDT