Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Conntect time

Re: Conntect time

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 23 Sep 1999 18:44:55 GMT
Message-ID: <7sdsf7$fqm$7@news.seed.net.tw>

<heldw_at_my-deja.com> wrote in message news:7s8q2t$u2q$1_at_nnrp1.deja.com...
> How can I get the time (begin / end !!)a user was connected to the
> server - Scripts ?
>
> Thank you in advance

Use "AUDIT SESSION" to audit user's logon/logoff, then, query the timestamp and logoff_time columns of the dba_audit_session view. Received on Thu Sep 23 1999 - 13:44:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US