一:查询当前正在执行的SQL:
SELECT a.sid, a.serial#, a.machine, a.username, b.hash_value, c.sql_text
FROM v$session a, v$sqlarea b, v$sqltext c
WHERE a.sql_hash_value = b.hash_value
AND b.hash_value = c.hash_value
ORDER BY b.hash_value, c.piece;
查询结果如下所示:
二:查看当前锁表信息:
SELECT l.session_id sid,
s.serial#,
l.locked_mode,
l.oracle_username,
l.os_user_name,
s.machine,
s.terminal,
o.object_name,
s.logon_time
FROM v$locked_object l, all_objects o, v$session s
WHERE l.object_id =