SR 4 DB

I am working in a new post : "Open Cursor Current by program", i hope to finish it next week. thanks for reading.

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