Itl Wait on LOB Index
SQL> select
2 OWNER,
3 OBJECT_NAME,
4 SUBOBJECT_NAME,
5 TABLESPACE_NAME,
6 OBJECT_TYPE, obj#,dataobj#,
7 STATISTIC_NAME,
8 VALUE
9 from v$segment_statistics
10 where
11 owner = '&owner' and
12 object_name = '&object_name'
13 order by owner,object_name,subobject_name,statistic_name
14 /
Enter value for owner: GENEVA_ADMIN
Enter value for object_name: SYS_IL0000102187C00004$$
OWNER OBJECT_NAME SUBOBJECT_NAME TABLESPACE_NAME OBJECT_TYPE OBJ# DATAOBJ# STATISTIC_NAME VALUE
---------- ------------------------- -------------------- --------------- -------------------- -------- ----------- ------------------------------ ----------------
GENEVA_ADM SYS_IL0000102187C00004$$ BILLDATA_LOB_DA INDEX 102189 484288 ITL waits 3472
2 OWNER,
3 OBJECT_NAME,
4 SUBOBJECT_NAME,
5 TABLESPACE_NAME,
6 OBJECT_TYPE, obj#,dataobj#,
7 STATISTIC_NAME,
8 VALUE
9 from v$segment_statistics
10 where
11 owner = '&owner' and
12 object_name = '&object_name'
13 order by owner,object_name,subobject_name,statistic_name
14 /
Enter value for owner: GENEVA_ADMIN
Enter value for object_name: SYS_IL0000102187C00004$$
OWNER OBJECT_NAME SUBOBJECT_NAME TABLESPACE_NAME OBJECT_TYPE OBJ# DATAOBJ# STATISTIC_NAME VALUE
---------- ------------------------- -------------------- --------------- -------------------- -------- ----------- ------------------------------ ----------------
GENEVA_ADM SYS_IL0000102187C00004$$ BILLDATA_LOB_DA INDEX 102189 484288 ITL waits 3472
0