创建索引锁的表
来源:互联网 发布:建行黄金软件下载 编辑:程序博客网 时间:2024/06/05 09:54
SQL> desc TEST_IDX Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(128) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) NAMESPACE NUMBER EDITION_NAME VARCHAR2(30)SQL> select * from v$mystat where rownum<2; SID STATISTIC# VALUE---------- ---------- ----------52 0 0SQL> create index test_idx_idx2 on test_idx(owner,created);SQL> select t3.program,t2.sid,t2.ID1,t2.ctime from (select sid, type, id1, id2, lmode, request, ctime from v$lock where sid in (select sid from v$lock where TYPE = 'TX' and LMODE = 6) and type='TM') t2, v$session t3 where t2.sid = t3.sid; 2 3 4 5 6 7 8 9 10 11 PROGRAM SID ID1------------------------------------------------ ---------- ---------- CTIME----------sqlplus@june (TNS V1-V3) 52 7491420sqlplus@june (TNS V1-V3) 52 1821SQL> select object_name from dba_objects where object_id in (74914,18);OBJECT_NAME--------------------------------------------------------------------------------OBJ$TEST_IDX可以看到创建索引锁的对象为OBJ$和TEST_IDX
0 0