-查找锁定表信息select p.spid, c.object_name, b.session_id, b.oracle_username, b.os_user_namefrom v$process p, v$session a, v$locked_object b, all_objects cwhere p.addr = a.paddr and a.process = b.process and c.object_id = b.object_id; —查找删除号SELECT dob.OBJECT_NAME Table_Name,lo.SESSION_ID||’, ‘||vss.SERIAL# 删除号,lo.locked_mode,lo.SESSION_ID, vss.SERIAL#,vss.action Action,vss.osuser OSUSER,vss.LOGON_TIME,vss.process AP_PID, VPS.SPID DB_PID ,vss.*From v$locked_object lo, dba_objects dob, v$session vss, V$PROCESS VPSWhere lo.OBJECT_ID = dob.OBJECT_IDand lo.SESSION_ID = vss.SIDAND VSS.paddr = VPS.addrorder by 2,3,DOB.object_name ;–删除进程 alter system kill session ’128, 3597′; alter system kill session ’49, 310′; alter system kill session ’84, 1986′; alter system kill session ’92, 9807′;