Database Administration (MOSC)

MOSC Banner

Itl Wait on LOB Index

edited Aug 30, 2018 5:28AM in Database Administration (MOSC) 4 comments
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center