Re: logon-timeaccount

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/05/04
Message-ID: <8erj7g$3uf$1@news3.isdnet.net>#1/1

You can activate the session auditing with the statement "ausdit_trail=db" in your init.ora file and the "audit session;" statement in SQL*Plus.
Then you can query the dba_audit_session view to get informations on sessions. For instance:

Column username FORMAT A12 HEADING "User Name" Column action_name FORMAT A20 HEADING "Last action" Column returncode FORMAT 9990 HEADING RC

Column time_        FORMAT A17   HEADING "Time"
Column con          FORMAT A17   HEADING "Deconnection"

select username, action_name, returncode,
       to_char(timestamp, 'MM-DD-YY HH24:MI:SS') time_,
       nvl(to_char(logoff_time, 'MM-DD-YY HH24:MI:SS'),
           decode(returncode,0,'Still connected','Connection ERROR') con

from dba_audit_session
order by timestamp asc
/

--
Have a nice day
Michel


<thorsten2103_at_my-deja.com> a écrit dans le message : 8epafd$ud0$1_at_nnrp1.deja.com...


> Hallo,

>

> it´s possible to count the connect-time per user to the database ?

> If yes, how ?

> We use Oracle8.0.5 on NT.

>

>

> Thanks.

> Thorsten

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Thu May 04 2000 - 00:00:00 CDT