Oracle Database Discussions

Hi ,

Was going through the MS Doc TX Transaction locks - Example wait scenarios (Doc ID 62354.1)

In that under Waits due to Insufficient 'ITL' slots in the block i executed the query it shows a index with high value for ITL waits

SQL>
SELECT t.OWNER, t.OBJECT_NAME, t.OBJECT_TYPE, t.STATISTIC_NAME, t.VALUE
     FROM v$segment_statistics t
     WHERE t.STATISTIC_NAME = 'ITL waits'
     AND t.VALUE > 0;
OWNER      OBJECT_NAME                    OBJECT_TYPE        STATISTIC_NAME                                                        VALUE
---------- ------------------------------ ------------------ ---------------------------------------------------------------- ----------
APPLSYS    FND_LOGINS_U1                  INDEX              ITL waits                                                                38

Is that initrans of this index has to be increased?? And also i increased the value of initrans of index from 10 to 30 and then executed the query again. It shows the same value? How do i verify if the ITL waits on this segment is resolved or not?

baskar.l