1
SQL> select object_id,session_id,locked_mode from v$locked_object;
2

3
 OBJECT_ID SESSION_ID LOCKED_MODE
4

5
---------- ---------- -----------
6

7
    74605         11           3
8

9
SQL> select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,
10

11
v$session t2 where t1.session_id=t2.sid order by t2.logon_time;
12

13
USERNAME                        SID        SERIAL#    LOGON_TIME
14

15
------------------------------ ---------- ---------- --------------
16

17
FSET                                11       2430     25-3月 -19
18

19
SQL>  alter system kill session '11,2430' ;
20

21
系统已更改。
22

23
SQL> select object_id,session_id,locked_mode from v$locked_object;
24

25
未选定行