摘要：--kill session语句1alter system kill SESSION '2171,60490';--以下几个为相关表1234567SELECT * FROM v$lock; SELECT * FROM v$sqlarea; SELECT * FROM v$session; SELECT * FROM v$process ; SELECT * FROM v$locked_object; SELECT * FROM all_objects; SELECT * FROM v$session_wait;--1.查出锁定object的session的信息以及被锁定的obj 阅读全文