oracle Ëø £¨²éѯ/½âËøÓï¾ä)

ͨ¹ý select * from table whereid=16701 for update ËøסһÕűí
ͨ¹ýÒÔÏÂÓï¾ä¿É²éѯ³ö±»ËøסµÄ¶ÔÏó
SELECT OBJECT_ID,
       SESSION_ID,
       SERIAL#,
       ORACLE_USERNAME,
       OS_USER_NAME,
       S.PROCESS
  from V$LOCKED_OBJECT A, V$SESSION S
 WHERE A.SESSION_ID = S.SID
ͨ¹ýÏÂÁÐÓï¾ä½øÐнâËø
 alter system kill session 'sid,serial#';