script untuk mengetahui session dan sql statement yg sedang berjalan

col sid format '9999'
col serial format '999'
col username format a9
col TIME format a20
col status format a8
col program format a28
col sql_text format a40

select a.sid, a.Serial#, a.username,
to_char(a.logon_time,'DD-MM-YYYY hh:mm:ss') as TIME,
a.status, a.program,
b.sql_text
from v$session a, v$sqlarea b
where
a.sql_address=b.address
and
a.username is not NULL
order by 4 desc;