select substr(s.username, 1, 12) username, substr(s.program, 1, 30) program,
s.sid, s.serial# s#, p.spid, substr(event, 1, 35) event, to_char(logon_time,'DD-MON-YYYY HH24:MI:SS') Login_Time
from v$session s, v$process p, v$session_wait w where s.sid = w.sid and p.addr = s.paddr
and s.username is not null
and event like 'library%'
order by logon_time desc
/
