1、查询哪些被锁表 select lo.SESSION_ID,lo.ORACLE_USERNAME,do.owner,do.object_type,do.object_name,s.osuser,s.SID,s.SERIAL#,s.STATUS,p.SPID
- from v$locked_object lo,dba_objects do,v$session s,v$process p where lo.OBJECT_ID=do.object_id and lo.SESSION_ID=s.SID and p.ADDR=s.PADDR;
2、运行脚本,KILL SESSION 解锁 --exec prc_kill_session(&USERNAME,&SID,&SERIAL#); exec prc_kill_session('epcissvropr','147','55933');