查看正在被占用的表

可以用于运行存储过程时，产看存储过程运行到操作哪张表。

selecta_s.owner,

a_s.object_name,

a_s.object_type,

vn.sid,

vn.serial#,

vs.spid"os_pid",

vn.process"client_pid",

vn.username,

vn.osuser,

vn.machine"hostname" ,

vn.terminal,

vn.program,

to_char(vn.logon_time,'yyyy-mm-ddhh24:mi:ss')"login_time",

'alter systemkill session '''||vn.sid||','||vn.serial#||''';' "oracke_kill",

'kill -9 '||vs.spid "os_kill"

fromall_objects a_s,

v$locked_objectv_t,

v$session vn,

v$process vs

wherea_s.object_id=v_t.object_id

andv_t.session_id =vn.sid

andvs.addr=vn.paddr

andvn.username not in('SYSMAN','SYS');