1033 GOEX_ADMIN robin pts/6 UL --Waiting-- Row Share
1073 GOEX_ADMIN robin pts/2 UL Exclusive
--下面释放session 1073的锁
1073@GOBO1> DECLARE
2 s VARCHAR2(200);
3 BEGIN
4 lock_demo.release_lock(s);
5 dbms_output.put_line(s);
6 END;
7 /
0
PL/SQL procedure successfully completed.
--Author : Robinson
1073@GOBO1> select * from lock_test;
ACTION WHEN
---------- --------------------------------------------------
started 20-JUN-13 05.00.36.845854000 PM
ended 20-JUN-13 05.00.41.841460000 PM
started 20-JUN-13 05.00.36.845385000 PM
ended 20-JUN-13 05.00.41.841064000 PM
started 20-JUN-13 04.39.46.303529000 PM
ended 20-JUN-13 04.39.51.345226000 PM