Useful oracle session info
set lines 1000 pages 200 break on inst_id skip 1 col sid format 9999 col serial# format 999999 col username format a10 col Command format a15 col machine format a15 col os_user format a15 col program format a35 col logontime format a17 col ospid format a10 col event format a55 col sql_text format a75 SELECT a.inst_id, a.sid, a.serial#, b.spid ospid, TO_CHAR(logon_time,'dd-Mon-rr hh24:mi') LogonTime, lower(a.username) username, lower(a.machine) machine, lower(status) status, rpad(lower(osuser),15,' ') OS_User, lower(a.program) program, decode(command,2,'INSERT',3,'SELECT',6,'UPDATE',7,'DELETE',47,'PL/SQL ...