topSELECT/+ordered/p.spid,s.sid,s.serial#,s.username,TO_CHAR(s.logon_time,'mm-dd-yyyyhh24:mi')logon_time,s.last_call_et,st.value,s.sql_hash_value,s.sql_address,sq.sql_textFROMv$statnamesn,v$sesstatst,v$processp,v$sessions,v$sqlsqWHEREs.paddr=p.addrAN...
(more)