--查看锁的情况
10:26:53 SQL> /
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK TABLE_NAME
---------- ---------- ------- ---------- ------------ ------------ ---------- ------- ------- ----- ------------------------------
315C66A8 315C66C0 147 TM 5180637 0 3 0 0 0 T_TEST
315C6550 315C6568 144 TM 5180637 0 2 0 1 0 T_TEST
3203444C 32034460 144 DL 5180637 0 3 0 2 0
32034394 320343A8 144 DL 5180637 0 3 0 2 0
315C65FC 315C6614 144 TM 5180671 0 4 0 1 0 SYS_JOURNAL_5180670
31627F54 31627F78 144 TX 327692 57125 6 0 2 0
6 rows selected.
Elapsed: 00:00:02.49
10:27:26 SQL>/
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK TABLE_NAME
---------- ---------- ------- ---------- ------------ ------------ ---------- ------- ------- ----- ------------------------------
315C66A8 315C66C0 147 TM 5180637 0 3 0 6 0 T_TEST
315C6550 315C6568 144 TM 5180637 0 2 0 7 0 T_TEST
3203444C 32034460 144 DL 5180637 0 3 0 8 0
32034394 320343A8 144 DL 5180637 0 3 0 8 0
315C65FC 315C6614 144 TM 5180671 0 4 0 7 0 SYS_JOURNAL_5180670
31627F54 31627F78 144 TX 327692 57125 6 0 8 0
31616060 31616084 147 TX 655370 57432 6 0 6 0
7 rows selected.
Elapsed: 00:00:02.16
10:27:38 SQL>/
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK TABLE_NAME
---------- ---------- ------- ---------- ------------ ------------ ---------- ------- ------- ----- ------------------------------
315C5A88 315C5AD0 144 TS 6 23579 6 0 3 0
315C66A8 315C66C0 147 TM 5180637 0 3 0 19 0 T_TEST
315C6550 315C6568 144 TM 5180637 0 2 0 20 0 T_TEST
3203444C 32034460 144 DL 5180637 0 3 0 21 0
32034394 320343A8 144 DL 5180637 0 3 0 21 0
315C65FC 315C6614 144 TM 5180671 0 4 0 20 0 SYS_JOURNAL_5180670
31627F54 31627F78 144 TX 327692 57125 6 0 21 0
31616060 31616084 147 TX 655370 57432 6 0 19 0
8 rows selected.
Elapsed: 00:00:00.17
10:28:29 SQL>/
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK TABLE_NAME
---------- ---------- ------- ---------- ------------ ------------ ---------- ------- ------- ----- ------------------------------
315C5A88 315C5AD0 144 TS 6 23579 6 0 52 0
315C66A8 315C66C0 147 TM 5180637 0 3 0 68 1 T_TEST
315C6550 315C6568 144 TM 5180637 0 2 4 69 0 T_TEST
3203444C 32034460 144 DL 5180637 0 3 0 70 0
32034394 320343A8 144 DL 5180637 0 3 0 70 0
315C65FC 315C6614 144 TM 5180671 0 4 0 69 0 SYS_JOURNAL_5180670
31627F54 31627F78 144 TX 327692 57125 6 0 70 0
31616060 31616084 147 TX 655370 57432 6 0 68 0
8 rows selected.
Elapsed: 00:00:00.14
--从锁的情况中看到创建索引过程中出现了表SYS_JOURNAL_5180670,查看表的相关信息
10:28:52 SQL> col partitioned for a20
10:29:02 SQL> col temporary for a20
10:29:08 SQL> select table_name, iot_type, partitioned, temporary from user_tables where table_name=\'SYS_JOURNAL_5180670\';
TABLE_NAME IOT_TYPE PARTITIONED TEMPORARY
------------------------------ ------------ -------------------- --------------------
SYS_JOURNAL_5180670 IOT NO N
Elapsed: 00:00:00.00
10:29:10 SQL> set line 100
10:29:15 SQL> desc SYS_JOURNAL_5180670
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
C0 NOT NULL NUMBER
OPCODE CHAR(1)
PARTNO NUMBER
RID NOT NULL ROWID
10:29:19 SQL> set line 200
10:29:37 SQL> select a.*, decode(a.type, \'TM\', b.object_name) table_name
10:29:48 2 from v$lock a, dba_objects b
10:29:48 3 where a.id1=b.object_id(+)
10:29:48 4 and a.sid in(144, 147);
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK TABLE_NAME
---------- ---------- ------- ---------- ------------ ------------ ---------- ------- ------- ----- ------------------------------
315C5A88 315C5AD0 144 TS 6 23579 6 0 132 0
315C66A8 315C66C0 147 TM 5180637 0 3 0 148 1 T_TEST
315C6550 315C6568 144 TM 5180637 0 2 4 149 0 T_TEST
3203444C 32034460 144 DL 5180637 0 3 0 150 0
32034394 320343A8 144 DL 5180637 0 3 0 150 0
315C65FC 315C6614 144 TM 5180671 0 4 0 149 0 SYS_JOURNAL_5180670
31627F54 31627F78 144 TX 327692 57125 6 0 150 0
31616060 31616084 147 TX 655370 57432 6 0 148 0
8 rows selected.
Elapsed: 00:00:00.13