Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Last Login Time
S_at_lut Chittesh,
You ve got to put your database in trace mode. Then look at table dba_audit_session;
if you do not want to trace you can create a script that regulary looks at table V$session and spools informations into a file (or feed a table)
>Hi,
>
>Is there a way to find the last login time for the users in Database?
>
>Any response on this will be highly appriciated.
>Thanks
>
>- Chittesh
Received on Thu Oct 29 1998 - 10:47:07 CST