Oracle中数据操作监控语句:
select t.sql_hash_value,
s2.sql_text,
s1.status,
t.sql_exec_start,
t.sofar,
t.totalwork,
t.time_remaining,
t.elapsed_seconds
from v$session_longops t, v$session s1, v$process p, v$sqlarea s2
where t.sql_id = s2.sql_id
and s1.paddr = p.addr
and t.sid = s1.sid
and t.serial# = s1.serial#
order by s1.terminal, t.username, t.sql_exec_start, t.start_time desc
select t.sql_hash_value,
s2.sql_text,
s1.status,
t.sql_exec_start,
t.sofar,
t.totalwork,
t.time_remaining,
t.elapsed_seconds
from v$session_longops t, v$session s1, v$process p, v$sqlarea s2
where t.sql_id = s2.sql_id
and s1.paddr = p.addr
and t.sid = s1.sid
and t.serial# = s1.serial#
order by s1.terminal, t.username, t.sql_exec_start, t.start_time desc