ITL Waits - Summary of Tablespace
If we saw "ITL Waits" in the report "Summary of Tablespace" section "Statistics", we can use this procedure to diagnostic and resolve that. We have used this method in high transactional environment and it worked very well in order to find problems and resolve. Step 01 - ITL Waits We run this query to know which segments have more ITL waits. SELECT Owner , Object_Name , Subobject_Name , Object_Type, Value FROM V$Segment_Statistics c WHERE Tablespace_Name = UPPER ( '&parTABLESPACE' ) AND Value > 0 AND Statistic_Name = 'ITL waits' ORDER BY Value DESC; Owner OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE VALUE ------------ --------------------------- ------------------- --------------------- --------- PTP THIAT_CONCILIACION_AA_1 TABLE