To finding ITL wait hot block objects to increace initrans

To finding ITL wait hot block objects to increace initrans

      select distinct b.object_name,b.object_type 
        from DBA_HIST_SEG_STAT a ,DBA_HIST_SEG_STAT_OBJ b
    where a.OBJ#=b.OBJ#
    and a. itl_waits_total>0
    and b.owner='&Schema_name'
    and a.TS#=b.TS#
    and  b.DATAOBJ#= a.DATAOBJ#
  and b.object_name not like 'SYS%'

Then alter the table or index as below.

ALTER table Schemaname.Object_name initrans 10;
ALTER index Schemaname.Object_name initrans 10;