×

Loading...

Topic

This topic has been archived. It cannot be replied.
  • 工作学习 / IT技术讨论 / 请教ORACLE问题，我的JAVA程序需要做一个TRANSACTION，在我COMMIT之前程序CRASH了。有没有SQL*PLUS的指令可以UNLOCK那个被由于需要TRANSACTION被LOCK的TABLE？（我现在只能重新启动ORACLE） -urfr(urfr); 2001-11-8 (#254546@0)
    • You can kill the session which caused the lock use the command ALTER SYSTEM KILL SESSION 'sid,serial#' -laotang(laotang); 2001-11-9 {229} (#254610@0)
      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!
      • 谢谢! -urfr(urfr); 2001-11-9 (#255629@0)
枫下论坛主坛 /  工作学习 /  IT技术讨论