Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tracking user log on's
Try this ...
select username, osuser, to_char(logon_time,'DD-Mon-YYYY HH24:MI:SS') time
from v$session
where username is not null
order by time
/
Received on Fri Jun 05 1998 - 00:00:00 CDT