You can kill the session which caused the lock use the command ALTER SYSTEM KILL SESSION 'sid,serial#'

laotang (laotang)
You can get the SID from v$locked_objects,then get SERIAL# from V$SESSION;
If you want to know which table is locked,query V$LOCKED_OBJECTS,
you can get OBJECT_ID, then query DBA_OBJECTS, you can get the table name.
Good Luck!
(#254610@0)
2001-11-9 -05:00

回到话题: 请教ORACLE问题,我的JAVA程序需要做一个TRANSACTION,在我COMMIT之前程序CRASH了。有没有SQL*PLUS的指令可以UNLOCK那个被由于需要TRANSACTION被LOCK的TABLE?(我现在只能重新启动ORACLE)

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=254610