Script to find Session_log_on_time

set line 200


col osuser format a10 trunc heading "OSUSER AS"

col orauser format a10 trunc

col machine format a10 trunc

col sprogram format a15 trunc

col process format a20 trunc

col server format a3 trunc

col sess_id format 9999

col proc_id format a10

col logon_time format a20

SELECT s.osuser osuser,

s.username orauser,

s.machine machine,

s.program sprogram,

p.program process,

s.sid sess_id,

s.serial# sess_num,

p.spid proc_id,

to_char(s.logon_time, 'hh24:mi dd/mm/yy') login_time,

s.server server,status

---s.client_info

FROM v$session s,

v$process p

WHERE s.paddr = p.addr

AND type != 'BACKGROUND'

AND p.username is not null

ORDER BY 9 desc

/

col osuser clear

col machine clear

col orauser clear

ttitle off