其他锁(系统锁)的记录:
CU-XXXXXXX-00000000 mode=6 Cursor bind 游标绑定锁 多个
DL-00015bb4-00000000 mode=3 指向TEXT_T1
OD-00015bda-00000000 mode=6 指向IND_TEXT02
FB-0000000e-018a85c0 mode=6 指向SEG$
TT-00000003-00000010 mode=4 指向I_OBJ#
TS-0000000e-018a85c2 mode=6 指向SEG$
TS-0000000e-01c00082 mode=6 指向SEG$
TS-0000000e-01c00083 mode=6 指向SEG$
HW-0000000e-018a85c2 mode=6 指向SEG$
DL-00015bb4-00000000 mode=3 指向TEXT_T1
PW-00000001-00000000 mode=4
MR-00000002-00000002 mode=4
2.Alter index rebuild online
Session 1
SQL> update text_t1 set OBJECT_ID=321 where OBJECT_ID=666;
SQL> alter session set events '10704 trace name context forever, level 12';
SQL> alter index ind_text02 rebuild online;
Session 2
SQL> select * from v$lock where sid=45;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
00000000BED5CE58 00000000BED5CEB0 45 DL 89012 0 3 0 73 0
00000000BED5D2B8 00000000BED5D310 45 TO 79833 1 3 0 48673 0
00000000BED5D398 00000000BED5D3F0 45 OD 89012 0 4 0 73 0
00000000BED5D558 00000000BED5D5B0 45 AE 100 0 4 0 48807 0
00000000BED5D650 00000000BED5D6A8 45 DL 89012 0 3 0 73 0
00000000BED5D730 00000000BED5D788 45 OD 89050 0 6 0 73 0
00007F4A6A48A3A8 00007F4A6A48A408 45 TM 89012 0 2 0 73 0
00007F4A6A48A3A8 00007F4A6A48A408 45 TM 89065 0 4 0 73 0
00000000BBE04B08 00000000BBE04BB8 45 TS 14 29360362 6 0 25 0
00000000BBEE55A8 00000000BBEE5620 45 TX 196637 1845 6 0 25 0
00000000BBF33FB8 00000000BBF34030 45 TX 196630 1844 6 0 73 0