DETAILED ADDM REPORT FOR TASK 'TASK_129684' WITH ID 129684
          ----------------------------------------------------------
 
              Analysis Period: from 20-JAN-2011 22:00 to 21-JAN-2011 14:00
         Database ID/Instance: 4127787440/2
      Database/Instance Names: CAPGENT/capgent2
                    Host Name: rac2.capgent.com
             Database Version: 10.2.0.4.0
               Snapshot Range: from 18093 to 18110
                Database Time: 409155 seconds
        Average Database Load: 7.1 active sessions
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
 
FINDING 1: 37% impact (151045 seconds)
--------------------------------------
SQL statements consuming significant database time were found.
 
   RECOMMENDATION 1: SQL Tuning, 11% benefit (44094 seconds)
      ACTION: Tune the PL/SQL block with SQL_ID "b6wt35s00ykqz". Refer to the 
         "Tuning PL/SQL Applications" chapter of Oracle's "PL/SQL User's Guide 
         and Reference"
         RELEVANT OBJECT: SQL statement with SQL_ID b6wt35s00ykqz
         DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME 
         ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(30) := 
         :job_name;  job_subname VARCHAR2(30) := :job_subname;  job_owner 
         VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := 
         :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := 
         :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := 
         :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  
         BEGIN  begin dbms_sqltune.execute_tuning_task('SQL_TUNING_12955909264
         76'); end;  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 
         0; END IF; END; 
 
   RECOMMENDATION 2: SQL Tuning, 10% benefit (42381 seconds)
      ACTION: Tune the PL/SQL block with SQL_ID "gs61dbk798uxn". Refer to the 
         "Tuning PL/SQL Applications" chapter of Oracle's "PL/SQL User's Guide 
         and Reference"
         RELEVANT OBJECT: SQL statement with SQL_ID gs61dbk798uxn
         DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME 
         ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(30) := 
         :job_name;  job_subname VARCHAR2(30) := :job_subname;  job_owner 
         VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := 
         :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := 
         :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := 
         :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  
         BEGIN  begin dbms_sqltune.execute_tuning_task('SQL_TUNING_12955926889
         17'); end;  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 
         0; END IF; END; 
 
   RECOMMENDATION 3: SQL Tuning, 9.2% benefit (37664 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "4fx1nsvwwbgm8".
         RELEVANT OBJECT: SQL statement with SQL_ID 4fx1nsvwwbgm8 and 
         PLAN_HASH 3177380161
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 
         :50)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and 
         invtxn0_.IV_CLOSED=0
      ACTION: Investigate the SQL statement with SQL_ID "4fx1nsvwwbgm8" for 
         possible performance improvements.
         RELEVANT OBJECT: SQL statement with SQL_ID 4fx1nsvwwbgm8 and 
         PLAN_HASH 3177380161
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 
         :50)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and 
         invtxn0_.IV_CLOSED=0
      RATIONALE: SQL statement with SQL_ID "4fx1nsvwwbgm8" was executed 319 
         times and had an average elapsed time of 79 seconds.
      RATIONALE: Waiting for event "db file sequential read" in wait class 
         "User I/O" accounted for 38% of the database time spent in processing 
         the SQL statement with SQL_ID "4fx1nsvwwbgm8".
      RATIONALE: Waiting for event "read by other session" in wait class "User 
         I/O" accounted for 20% of the database time spent in processing the 
         SQL statement with SQL_ID "4fx1nsvwwbgm8".
      RATIONALE: Waiting for event "gc buffer busy" in wait class "Cluster" 
         accounted for 18% of the database time spent in processing the SQL 
         statement with SQL_ID "4fx1nsvwwbgm8".
 
   RECOMMENDATION 4: SQL Tuning, 6.1% benefit (25058 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "fmn7h9fupj823".
         RELEVANT OBJECT: SQL statement with SQL_ID fmn7h9fupj823 and 
         PLAN_HASH 1910842901
         DELETE FROM CST_HDR where en_id=3940
      RATIONALE: SQL statement with SQL_ID "fmn7h9fupj823" was executed 1 
         times and had an average elapsed time of 24968 seconds.
 
   RECOMMENDATION 5: SQL Tuning, 3.5% benefit (14154 seconds)
      ACTION: Investigate the SQL statement with SQL_ID "cvnfcdk2fnnsv" for 
         possible performance improvements.
         RELEVANT OBJECT: SQL statement with SQL_ID cvnfcdk2fnnsv
         call ALL_ENTITY_AGE_CALCULATIONS (  )
 
FINDING 2: 25% impact (102000 seconds)
--------------------------------------
SQL statements were not shared due to the usage of literals. This resulted in 
additional hard parses which were consuming significant database time.
 
   RECOMMENDATION 1: Application Analysis, 25% benefit (102000 seconds)
      ACTION: Investigate application logic for possible use of bind variables 
         instead of literals.
      ACTION: Alternatively, you may set the parameter "cursor_sharing" to 
         "force".
      RATIONALE: At least 1065 SQL statements with PLAN_HASH_VALUE 3931611195 
         were found to be using literals. Look in V$SQL for examples of such 
         SQL statements.
      RATIONALE: At least 149 SQL statements with PLAN_HASH_VALUE 2437727371 
         were found to be using literals. Look in V$SQL for examples of such 
         SQL statements.
      RATIONALE: At least 41 SQL statements with PLAN_HASH_VALUE 2919750023 
         were found to be using literals. Look in V$SQL for examples of such 
         SQL statements.
      RATIONALE: At least 34 SQL statements with PLAN_HASH_VALUE 3278893800 
         were found to be using literals. Look in V$SQL for examples of such 
         SQL statements.
      RATIONALE: At least 26 SQL statements with PLAN_HASH_VALUE 3484722902 
         were found to be using literals. Look in V$SQL for examples of such 
         SQL statements.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Hard parsing of SQL statements was consuming significant 
               database time. (46% impact [186603 seconds])
         SYMPTOM: Contention for latches related to the shared pool was 
                  consuming significant database time. (45% impact [183373 
                  seconds])
            INFO: Waits for "library cache lock" amounted to 28% of database 
                  time.
                  Waits for "cursor: pin S wait on X" amounted to 16% of 
                  database time.
            SYMPTOM: Wait class "Concurrency" was consuming significant 
                     database time. (45% impact [183457 seconds])
 
FINDING 3: 21% impact (84582 seconds)
-------------------------------------
Hard parsing SQL statements that encountered parse errors was consuming 
significant database time.
 
   RECOMMENDATION 1: Application Analysis, 21% benefit (84582 seconds)
      ACTION: Investigate application logic to eliminate parse errors.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Hard parsing of SQL statements was consuming significant 
               database time. (46% impact [186603 seconds])
         SYMPTOM: Contention for latches related to the shared pool was 
                  consuming significant database time. (45% impact [183373 
                  seconds])
            INFO: Waits for "library cache lock" amounted to 28% of database 
                  time.
                  Waits for "cursor: pin S wait on X" amounted to 16% of 
                  database time.
            SYMPTOM: Wait class "Concurrency" was consuming significant 
                     database time. (45% impact [183457 seconds])
 
FINDING 4: 17% impact (68309 seconds)
-------------------------------------
Soft parsing of SQL statements was consuming significant database time.
 
   RECOMMENDATION 1: Application Analysis, 17% benefit (68309 seconds)
      ACTION: Investigate application logic to keep open the frequently used 
         cursors. Note that cursors are closed by both cursor close calls and 
         session disconnects.
 
   RECOMMENDATION 2: DB Configuration, 17% benefit (68309 seconds)
      ACTION: Consider increasing the maximum number of open cursors a session 
         can have by increasing the value of parameter "open_cursors".
      ACTION: Consider increasing the session cursor cache size by increasing 
         the value of parameter "session_cached_cursors".
      RATIONALE: The value of parameter "open_cursors" was "2000" during the 
         analysis period.
      RATIONALE: The value of parameter "session_cached_cursors" was "20" 
         during the analysis period.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Contention for latches related to the shared pool was consuming 
               significant database time. (45% impact [183373 seconds])
         INFO: Waits for "library cache lock" amounted to 28% of database 
               time.
               Waits for "cursor: pin S wait on X" amounted to 16% of database 
               time.
         SYMPTOM: Wait class "Concurrency" was consuming significant database 
                  time. (45% impact [183457 seconds])
 
FINDING 5: 15% impact (63087 seconds)
-------------------------------------
Individual database segments responsible for significant user I/O wait were 
found.
 
   RECOMMENDATION 1: Segment Tuning, 8.9% benefit (36377 seconds)
      ACTION: Run "Segment Advisor" on TABLE "DNBI.INV_TXN" with object id 
         56469.
         RELEVANT OBJECT: database object with id 56469
      ACTION: Investigate application logic involving I/O on TABLE 
         "DNBI.INV_TXN" with object id 56469.
         RELEVANT OBJECT: database object with id 56469
      RATIONALE: The I/O usage statistics for the object are: 518 full object 
         scans, 3194478 physical reads, 11775 physical writes and 0 direct 
         reads.
      RATIONALE: The SQL statement with SQL_ID "4fx1nsvwwbgm8" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 4fx1nsvwwbgm8
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 
         :50)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and 
         invtxn0_.IV_CLOSED=0
      RATIONALE: The SQL statement with SQL_ID "dcnp1pu6hd5fs" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID dcnp1pu6hd5fs
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 
         :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 
         , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , 
         :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 
         , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , 
         :96 , :97 , :98 , :99 , :100)) and 
         invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0
      RATIONALE: The SQL statement with SQL_ID "4hwgx07x6cctb" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 4hwgx07x6cctb
         update CST_HDR set CS_STMT=2 where (CS_ID in (select csthdr1_.CS_ID 
         from CST_HDR csthdr1_, INV_TXN invtxns2_, ADD_HDR addhdrs3_ where 
         csthdr1_.CS_ID=invtxns2_.CS_ID(+) and 
         csthdr1_.CS_ID=addhdrs3_.AD_LINK(+) and csthdr1_.CS_ACTIVE=1 and 
         invtxns2_.IV_TYPE='Account' and trunc(sysdate-invtxns2_.IV_DATE4)=54 
         and invtxns2_.IV_TXAMT>0 and csthdr1_.CS_NUM9>invtxns2_.IV_TXAMT/10 
         and (csthdr1_.CS_STMT is null or csthdr1_.CS_STMT<>2) and 
         (addhdrs3_.AD_ID in (select max(addhdr4_.AD_ID) from ADD_HDR addhdr4_ 
         where addhdr4_.AD_LINK=csthdr1_.CS_ID and 
         lower(addhdr4_.AD_STR4)='osg')))) and EN_ID=4160
      RATIONALE: The SQL statement with SQL_ID "ad5ar868dyzgv" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID ad5ar868dyzgv
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49)) 
         and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0
      RATIONALE: The SQL statement with SQL_ID "8z06089cp2nd7" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 8z06089cp2nd7
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48)) and 
         invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and invtxn0_.IV_CLOSED=0
 
   RECOMMENDATION 2: Segment Tuning, 3.4% benefit (13926 seconds)
      ACTION: Run "Segment Advisor" on TABLE "DNBI.STS_LOG" with object id 
         56506.
         RELEVANT OBJECT: database object with id 56506
      ACTION: Investigate application logic involving I/O on TABLE 
         "DNBI.STS_LOG" with object id 56506.
         RELEVANT OBJECT: database object with id 56506
      RATIONALE: The I/O usage statistics for the object are: 218 full object 
         scans, 13833080 physical reads, 15040 physical writes and 0 direct 
         reads.
      RATIONALE: The SQL statement with SQL_ID "fmn7h9fupj823" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID fmn7h9fupj823
         DELETE FROM CST_HDR where en_id=3940
      RATIONALE: The SQL statement with SQL_ID "cju35by51ry35" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID cju35by51ry35
         select stslogs0_.IV_ID as IV16_1_, stslogs0_.IV_DATE as IV17_1_, 
         stslogs0_.LOG_ID as LOG1_1_, stslogs0_.LOG_ID as LOG1_73_0_, 
         stslogs0_.ST_IDT1 as ST2_73_0_, stslogs0_.ST_IDT2 as ST3_73_0_, 
         stslogs0_.ST_TXNTPE as ST4_73_0_, stslogs0_.ST_DESC as ST5_73_0_, 
         stslogs0_.ST_CRTDBY as ST6_73_0_, stslogs0_.ST_MODBY as ST7_73_0_, 
         stslogs0_.ST_CRTDDT as ST8_73_0_, stslogs0_.ST_MODDT as ST9_73_0_, 
         stslogs0_.ST_ISCURR as ST10_73_0_, stslogs0_.EN_ID as EN11_73_0_, 
         stslogs0_.STE_ID as STE12_73_0_, stslogs0_.TID as TID73_0_, 
         stslogs0_.AID as AID73_0_, stslogs0_.ST_ID as ST15_73_0_, 
         stslogs0_.IV_ID as IV16_73_0_, stslogs0_.IV_DATE as IV17_73_0_, 
         stslogs0_.CS_ID as CS18_73_0_ from STS_LOG stslogs0_ where  ( 
         stslogs0_.st_iscurr=1 and stslogs0_.st_txntpe='Receivables')  and 
         ((stslogs0_.IV_ID=:1 and stslogs0_.IV_DATE=:2) or (stslogs0_.IV_ID=:3 
         and stslogs0_.IV_DATE=:4) or (stslogs0_.IV_ID=:5 and 
         stslogs0_.IV_DATE=:6) or (stslogs0_.IV_ID=:7 and 
         stslogs0_.IV_DATE=:8) or (stslogs0_.IV_ID=:9 and 
         stslogs0_.IV_DATE=:10) or (stslogs0_.IV_ID=:11 and 
         stslogs0_.IV_DATE=:12) or (stslogs0_.IV_ID=:13 and 
         stslogs0_.IV_DATE=:14) or (stslogs0_.IV_ID=:15 and 
         stslogs0_.IV_DATE=:16) or (stslogs0_.IV_ID=:17 and 
         stslogs0_.IV_DATE=:18) or (stslogs0_.IV_ID=:19 and 
         stslogs0_.IV_DATE=:20) or (stslogs0_.IV_ID=:21 and 
         stslogs0_.IV_DATE=:22) or (stslogs0_.IV_ID=:23 and 
         stslogs0_.IV_DATE=:24) or (stslogs0_.IV_ID=:25 and 
         stslogs0_.IV_DATE=:26) or (stslogs0_.IV_ID=:27 and 
         stslogs0_.IV_DATE=:28) or (stslogs0_.IV_ID=:29 and 
         stslogs0_.IV_DATE=:30) or (stslogs0_.IV_ID=:31 and 
         stslogs0_.IV_DATE=:32) or (stslogs0_.IV_ID=:33 and 
         stslogs0_.IV_DATE=:34) or (stslogs0_.IV_ID=:35 and 
         stslogs0_.IV_DATE=:36) or (stslogs0_.IV_ID=:37 and 
         stslogs0_.IV_DATE=:38) or (stslogs0_.IV_ID=:39 and 
         stslogs0_.IV_DATE=:40) or (stslogs0_.IV_ID=:41 and 
         stslogs0_.IV_DATE=:42) or (stslogs0_.IV_ID=:43 and 
         stslogs0_.IV_DATE=:44) or (stslogs0_.IV_ID=:45 and 
         stslogs0_.IV_DATE=:46) or (stslogs0_.IV_ID=:47 and 
         stslogs0_.IV_DATE=:48) or (stslogs0_.IV_ID=:49 and 
         stslogs0_.IV_DATE=:50))
      RATIONALE: The SQL statement with SQL_ID "3qn0by9h14qff" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 3qn0by9h14qff
         select * from ( select invtxn1_.IV_GPINVNO as col_0_0_, 
         stslog0_.ST_CRTDDT as col_1_0_, stslog0_.ST_CRTDBY as col_2_0_, 
         stshdr2_.ST_NAME as col_3_0_, stslog0_.LOG_ID as col_4_0_, 
         invtxn1_.CS_ID as col_5_0_, stslog0_.IV_ID as col_6_0_, 
         stshdr2_.ST_ICON as col_7_0_ from STS_LOG stslog0_, INV_TXN invtxn1_, 
         STS_HDR stshdr2_ where stslog0_.IV_ID=invtxn1_.IV_ID and 
         stslog0_.IV_DATE=invtxn1_.IV_DATE and stslog0_.ST_ID=stshdr2_.ST_ID 
         and (invtxn1_.EN_ID in (4160)) and stslog0_.ST_TXNTPE<>'LOCK' order 
         by stslog0_.ST_CRTDDT DESC ) where rownum <= :1
      RATIONALE: The SQL statement with SQL_ID "8tptam3h5qmfw" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 8tptam3h5qmfw
         select stslogs0_.IV_ID as IV16_1_, stslogs0_.IV_DATE as IV17_1_, 
         stslogs0_.LOG_ID as LOG1_1_, stslogs0_.LOG_ID as LOG1_73_0_, 
         stslogs0_.ST_IDT1 as ST2_73_0_, stslogs0_.ST_IDT2 as ST3_73_0_, 
         stslogs0_.ST_TXNTPE as ST4_73_0_, stslogs0_.ST_DESC as ST5_73_0_, 
         stslogs0_.ST_CRTDBY as ST6_73_0_, stslogs0_.ST_MODBY as ST7_73_0_, 
         stslogs0_.ST_CRTDDT as ST8_73_0_, stslogs0_.ST_MODDT as ST9_73_0_, 
         stslogs0_.ST_ISCURR as ST10_73_0_, stslogs0_.EN_ID as EN11_73_0_, 
         stslogs0_.STE_ID as STE12_73_0_, stslogs0_.TID as TID73_0_, 
         stslogs0_.AID as AID73_0_, stslogs0_.ST_ID as ST15_73_0_, 
         stslogs0_.IV_ID as IV16_73_0_, stslogs0_.IV_DATE as IV17_73_0_, 
         stslogs0_.CS_ID as CS18_73_0_ from STS_LOG stslogs0_ where  ( 
         stslogs0_.st_iscurr=1 and stslogs0_.st_txntpe='Receivables')  and 
         ((stslogs0_.IV_ID=:1 and stslogs0_.IV_DATE=:2) or (stslogs0_.IV_ID=:3 
         and stslogs0_.IV_DATE=:4) or (stslogs0_.IV_ID=:5 and 
         stslogs0_.IV_DATE=:6) or (stslogs0_.IV_ID=:7 and 
         stslogs0_.IV_DATE=:8))
      RATIONALE: The SQL statement with SQL_ID "80xsxk5t87jya" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 80xsxk5t87jya
         select stslogs0_.IV_ID as IV16_1_, stslogs0_.IV_DATE as IV17_1_, 
         stslogs0_.LOG_ID as LOG1_1_, stslogs0_.LOG_ID as LOG1_73_0_, 
         stslogs0_.ST_IDT1 as ST2_73_0_, stslogs0_.ST_IDT2 as ST3_73_0_, 
         stslogs0_.ST_TXNTPE as ST4_73_0_, stslogs0_.ST_DESC as ST5_73_0_, 
         stslogs0_.ST_CRTDBY as ST6_73_0_, stslogs0_.ST_MODBY as ST7_73_0_, 
         stslogs0_.ST_CRTDDT as ST8_73_0_, stslogs0_.ST_MODDT as ST9_73_0_, 
         stslogs0_.ST_ISCURR as ST10_73_0_, stslogs0_.EN_ID as EN11_73_0_, 
         stslogs0_.STE_ID as STE12_73_0_, stslogs0_.TID as TID73_0_, 
         stslogs0_.AID as AID73_0_, stslogs0_.ST_ID as ST15_73_0_, 
         stslogs0_.IV_ID as IV16_73_0_, stslogs0_.IV_DATE as IV17_73_0_, 
         stslogs0_.CS_ID as CS18_73_0_ from STS_LOG stslogs0_ where  ( 
         stslogs0_.st_iscurr=1 and stslogs0_.st_txntpe='Receivables')  and 
         stslogs0_.IV_ID=:1 and stslogs0_.IV_DATE=:2
 
   RECOMMENDATION 3: Segment Tuning, 3.1% benefit (12783 seconds)
      ACTION: Run "Segment Advisor" on TABLE "DNBI.CMTS_LOG" with object id 
         56446.
         RELEVANT OBJECT: database object with id 56446
      ACTION: Investigate application logic involving I/O on TABLE 
         "DNBI.CMTS_LOG" with object id 56446.
         RELEVANT OBJECT: database object with id 56446
      RATIONALE: The I/O usage statistics for the object are: 219 full object 
         scans, 12047765 physical reads, 5657 physical writes and 0 direct 
         reads.
      RATIONALE: The SQL statement with SQL_ID "fmn7h9fupj823" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID fmn7h9fupj823
         DELETE FROM CST_HDR where en_id=3940
      RATIONALE: The SQL statement with SQL_ID "5d94rgkdz57qg" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID 5d94rgkdz57qg
         select cmtslogs0_.CM_IVID as CM18_1_, cmtslogs0_.CM_IVDATE as 
         CM19_1_, cmtslogs0_.CLOG_ID as CLOG1_1_, cmtslogs0_.CLOG_ID as 
         CLOG1_17_0_, cmtslogs0_.CM_TEXT as CM2_17_0_, cmtslogs0_.CM_IDT1 as 
         CM3_17_0_, cmtslogs0_.CM_IDT2 as CM4_17_0_, cmtslogs0_.CM_TXNTPE as 
         CM5_17_0_, cmtslogs0_.CM_CRTDBY as CM6_17_0_, cmtslogs0_.CM_MODBY as 
         CM7_17_0_, cmtslogs0_.CM_CRTDT as CM8_17_0_, cmtslogs0_.CM_MODDT as 
         CM9_17_0_, cmtslogs0_.CM_ACTION as CM10_17_0_, cmtslogs0_.CM_ACTICON 
         as CM11_17_0_, cmtslogs0_.EN_ID as EN12_17_0_, cmtslogs0_.STE_ID as 
         STE13_17_0_, cmtslogs0_.CM_ISCURR as CM14_17_0_, cmtslogs0_.TID as 
         TID17_0_, cmtslogs0_.AID as AID17_0_, cmtslogs0_.rowid as 
         rowid17_17_0_, cmtslogs0_.CM_IVID as CM18_17_0_, cmtslogs0_.CM_IVDATE 
         as CM19_17_0_, cmtslogs0_.CM_CSID as CM20_17_0_ from CMTS_LOG 
         cmtslogs0_ where  ( cmtslogs0_.cm_iscurr=1)  and 
         ((cmtslogs0_.CM_IVID=:1 and cmtslogs0_.CM_IVDATE=:2) or 
         (cmtslogs0_.CM_IVID=:3 and cmtslogs0_.CM_IVDATE=:4) or 
         (cmtslogs0_.CM_IVID=:5 and cmtslogs0_.CM_IVDATE=:6) or 
         (cmtslogs0_.CM_IVID=:7 and cmtslogs0_.CM_IVDATE=:8) or 
         (cmtslogs0_.CM_IVID=:9 and cmtslogs0_.CM_IVDATE=:10) or 
         (cmtslogs0_.CM_IVID=:11 and cmtslogs0_.CM_IVDATE=:12) or 
         (cmtslogs0_.CM_IVID=:13 and cmtslogs0_.CM_IVDATE=:14) or 
         (cmtslogs0_.CM_IVID=:15 and cmtslogs0_.CM_IVDATE=:16) or 
         (cmtslogs0_.CM_IVID=:17 and cmtslogs0_.CM_IVDATE=:18) or 
         (cmtslogs0_.CM_IVID=:19 and cmtslogs0_.CM_IVDATE=:20) or 
         (cmtslogs0_.CM_IVID=:21 and cmtslogs0_.CM_IVDATE=:22) or 
         (cmtslogs0_.CM_IVID=:23 and cmtslogs0_.CM_IVDATE=:24) or 
         (cmtslogs0_.CM_IVID=:25 and cmtslogs0_.CM_IVDATE=:26) or 
         (cmtslogs0_.CM_IVID=:27 and cmtslogs0_.CM_IVDATE=:28) or 
         (cmtslogs0_.CM_IVID=:29 and cmtslogs0_.CM_IVDATE=:30) or 
         (cmtslogs0_.CM_IVID=:31 and cmtslogs0_.CM_IVDATE=:32) or 
         (cmtslogs0_.CM_IVID=:33 and cmtslogs0_.CM_IVDATE=:34) or 
         (cmtslogs0_.CM_IVID=:35 and cmtslogs0_.CM_IVDATE=:36) or 
         (cmtslogs0_.CM_IVID=:37 and cmtslogs0_.CM_IVDATE=:38) or 
         (cmtslogs0_.CM_IVID=:39 and cmtslogs0_.CM_IVDATE=:40) or 
         (cmtslogs0_.CM_IVID=:41 and cmtslogs0_.CM_IVDATE=:42) or 
         (cmtslogs0_.CM_IVID=:43 and cmtslogs0_.CM_IVDATE=:44) or 
         (cmtslogs0_.CM_IVID=:45 and cmtslogs0_.CM_IVDATE=:46) or 
         (cmtslogs0_.CM_IVID=:47 and cmtslogs0_.CM_IVDATE=:48) or 
         (cmtslogs0_.CM_IVID=:49 and cmtslogs0_.CM_IVDATE=:50))
      RATIONALE: The SQL statement with SQL_ID "g1y6gy5krvh24" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID g1y6gy5krvh24
         select * from ( select stshdr3_.ST_NAME as col_0_0_, csthdr4_.CS_REF1 
         as col_1_0_, csthdr4_.CS_NAME as col_2_0_, invtxn0_.IV_GPINVNO as 
         col_3_0_, invtxn0_.IV_TLAMT as col_4_0_, invtxn0_.IV_DUEDATE as 
         col_5_0_, attmtslogs2_.AT_URL as col_6_0_, cmtslogs1_.CM_TEXT as 
         col_7_0_, invtxn0_.IV_STR4 as col_8_0_, invtxn0_.IV_STR5 as col_9_0_, 
         invtxn0_.IV_MODDT as col_10_0_, invtxn0_.IV_ASSGNTO as col_11_0_, 
         invtxn0_.IV_ID as col_12_0_, invtxn0_.IV_DATE as col_13_0_, 
         invtxn0_.IV_STID as col_14_0_, invtxn0_.CS_ID as col_15_0_, 
         attmtslogs2_.AT_DESC as col_16_0_, attmtslogs2_.ALOG_ID as col_17_0_, 
         stshdr3_.ST_ICON as col_18_0_ from INV_TXN invtxn0_, CMTS_LOG 
         cmtslogs1_, ATTMTS_LOG attmtslogs2_, CST_HDR csthdr4_, STS_HDR 
         stshdr3_ where invtxn0_.IV_ID=cmtslogs1_.CM_IVID(+) and 
         invtxn0_.IV_DATE=cmtslogs1_.CM_IVDATE(+) and ( 
         cmtslogs1_.cm_iscurr(+)=1) and invtxn0_.IV_ID=attmtslogs2_.AT_IVID(+) 
         and invtxn0_.IV_DATE=attmtslogs2_.AT_DATE(+) and 
         (attmtslogs2_.AT_ISINV(+)=1) and invtxn0_.CS_ID=csthdr4_.CS_ID and 
         (invtxn0_.EN_ID in (3650)) and invtxn0_.IV_TYPE='Invoice' and 
         invtxn0_.IV_STID=stshdr3_.ST_ID and invtxn0_.IV_CLOSED=1 order by 
         invtxn0_.IV_DUEDATE DESC ) where rownum <= :1
      RATIONALE: The SQL statement with SQL_ID "bmpb8ajdburxm" spent 
         significant time waiting for User I/O on the hot object.
         RELEVANT OBJECT: SQL statement with SQL_ID bmpb8ajdburxm
         
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (19% impact [75802 seconds])
 
FINDING 6: 10% impact (42240 seconds)
-------------------------------------
Individual SQL statements responsible for significant user I/O wait were 
found.
 
   RECOMMENDATION 1: SQL Tuning, 9.2% benefit (37664 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "4fx1nsvwwbgm8".
         RELEVANT OBJECT: SQL statement with SQL_ID 4fx1nsvwwbgm8 and 
         PLAN_HASH 3177380161
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 
         :50)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and 
         invtxn0_.IV_CLOSED=0
      ACTION: Investigate the SQL statement with SQL_ID "4fx1nsvwwbgm8" for 
         possible performance improvements.
         RELEVANT OBJECT: SQL statement with SQL_ID 4fx1nsvwwbgm8 and 
         PLAN_HASH 3177380161
         select invtxn0_.IV_ID as IV1_36_0_, invtxn0_.IV_DATE as IV2_36_0_, 
         csthdr1_.CS_ID as CS1_22_1_, accrtxn2_.IV_ID as IV1_1_2_, 
         accrtxn2_.IV_DATE as IV2_1_2_, invtxn0_.IV_PINVID as IV3_36_0_, 
         invtxn0_.IV_SBID as IV4_36_0_, invtxn0_.IV_CURR as IV5_36_0_, 
         invtxn0_.IV_CHGS as IV6_36_0_, invtxn0_.IV_TLAMT as IV7_36_0_, 
         invtxn0_.IV_SHPADD as IV8_36_0_, invtxn0_.IV_BLNO as IV9_36_0_, 
         invtxn0_.IV_SHMODE as IV10_36_0_, invtxn0_.IV_CARR as IV11_36_0_, 
         invtxn0_.IV_BILLADD as IV12_36_0_, invtxn0_.IV_CRTRMS as IV13_36_0_, 
         invtxn0_.IV_TERMS as IV14_36_0_, invtxn0_.IV_ATTDTLS as IV15_36_0_, 
         invtxn0_.IV_TEXT as IV16_36_0_, invtxn0_.IV_BTCHDTE as IV17_36_0_, 
         invtxn0_.IV_ADVPAID as IV18_36_0_, invtxn0_.IV_ADVADJ as IV19_36_0_, 
         invtxn0_.IV_PRNTD as IV20_36_0_, invtxn0_.IV_MODE as IV21_36_0_, 
         invtxn0_.IV_DUEDATE as IV22_36_0_, invtxn0_.IV_TARIFF as IV23_36_0_, 
         invtxn0_.IV_TXNDTE as IV24_36_0_, invtxn0_.IV_GPINVNO as IV25_36_0_, 
         invtxn0_.IV_CRTDBY as IV26_36_0_, invtxn0_.IV_MODBY as IV27_36_0_, 
         invtxn0_.IV_CRTDDT as IV28_36_0_, invtxn0_.IV_MODDT as IV29_36_0_, 
         invtxn0_.IV_CUSNO as IV30_36_0_, invtxn0_.IV_ASSGTPE as IV31_36_0_, 
         invtxn0_.IV_ASSGNTO as IV32_36_0_, invtxn0_.IV_STR1 as IV33_36_0_, 
         invtxn0_.IV_STR2 as IV34_36_0_, invtxn0_.IV_STR3 as IV35_36_0_, 
         invtxn0_.IV_STR4 as IV36_36_0_, invtxn0_.IV_STR5 as IV37_36_0_, 
         invtxn0_.IV_STR6 as IV38_36_0_, invtxn0_.IV_STR7 as IV39_36_0_, 
         invtxn0_.IV_STR8 as IV40_36_0_, invtxn0_.IV_STR9 as IV41_36_0_, 
         invtxn0_.IV_STR10 as IV42_36_0_, invtxn0_.IV_STR11 as IV43_36_0_, 
         invtxn0_.IV_STR12 as IV44_36_0_, invtxn0_.IV_STR13 as IV45_36_0_, 
         invtxn0_.IV_STR14 as IV46_36_0_, invtxn0_.IV_STR15 as IV47_36_0_, 
         invtxn0_.IV_STR16 as IV48_36_0_, invtxn0_.IV_STR17 as IV49_36_0_, 
         invtxn0_.IV_STR18 as IV50_36_0_, invtxn0_.IV_STR19 as IV51_36_0_, 
         invtxn0_.IV_STR20 as IV52_36_0_, invtxn0_.IV_STR21 as IV53_36_0_, 
         invtxn0_.IV_STR22 as IV54_36_0_, invtxn0_.IV_STR23 as IV55_36_0_, 
         invtxn0_.IV_STR24 as IV56_36_0_, invtxn0_.IV_STR25 as IV57_36_0_, 
         invtxn0_.IV_NUM1 as IV58_36_0_, invtxn0_.IV_NUM2 as IV59_36_0_, 
         invtxn0_.IV_NUM3 as IV60_36_0_, invtxn0_.IV_NUM4 as IV61_36_0_, 
         invtxn0_.IV_NUM5 as IV62_36_0_, invtxn0_.IV_NUM6 as IV63_36_0_, 
         invtxn0_.IV_NUM7 as IV64_36_0_, invtxn0_.IV_NUM8 as IV65_36_0_, 
         invtxn0_.IV_NUM9 as IV66_36_0_, invtxn0_.IV_NUM10 as IV67_36_0_, 
         invtxn0_.IV_DATE1 as IV68_36_0_, invtxn0_.IV_DATE2 as IV69_36_0_, 
         invtxn0_.IV_DATE3 as IV70_36_0_, invtxn0_.IV_DATE4 as IV71_36_0_, 
         invtxn0_.IV_DATE5 as IV72_36_0_, invtxn0_.IV_DATE6 as IV73_36_0_, 
         invtxn0_.IV_DATE8 as IV74_36_0_, invtxn0_.IV_DATE9 as IV75_36_0_, 
         invtxn0_.IV_DATE10 as IV76_36_0_, invtxn0_.IV_ORDNO as IV77_36_0_, 
         invtxn0_.IV_FOR as IV78_36_0_, invtxn0_.IV_REMTO as IV79_36_0_, 
         invtxn0_.IV_PRODCDE as IV80_36_0_, invtxn0_.IV_CNTRLNO as IV81_36_0_, 
         invtxn0_.IV_IONUM as IV82_36_0_, invtxn0_.IV_AUTHNO as IV83_36_0_, 
         invtxn0_.IV_DEPTNO as IV84_36_0_, invtxn0_.IV_LOC as IV85_36_0_, 
         invtxn0_.IV_CLOSED as IV86_36_0_, invtxn0_.TID as TID36_0_, 
         invtxn0_.AID as AID36_0_, invtxn0_.IV_SOURCE as IV89_36_0_, 
         invtxn0_.IV_RECTYPE as IV90_36_0_, invtxn0_.IV_SLSORDNO as 
         IV91_36_0_, invtxn0_.IV_GAMT as IV92_36_0_, invtxn0_.IV_TXAMT as 
         IV93_36_0_, invtxn0_.IV_PDAMT as IV94_36_0_, invtxn0_.IV_BU as 
         IV95_36_0_, invtxn0_.IV_SHREF as IV96_36_0_, invtxn0_.IV_SHCLASS as 
         IV97_36_0_, invtxn0_.IV_SHDT as IV98_36_0_, invtxn0_.IV_PODATE as 
         IV99_36_0_, invtxn0_.IV_PROREF as IV100_36_0_, invtxn0_.IV_BLDATEFRO 
         as IV101_36_0_, invtxn0_.IV_BLDATETO as IV102_36_0_, 
         invtxn0_.IV_BATCH as IV103_36_0_, invtxn0_.IV_SLDATE as IV104_36_0_, 
         invtxn0_.IV_GROUP as IV105_36_0_, invtxn0_.IV_SHADDDET as 
         IV106_36_0_, invtxn0_.IV_RESP as IV107_36_0_, invtxn0_.IV_REMDT as 
         IV108_36_0_, invtxn0_.IV_PROB as IV109_36_0_, invtxn0_.IV_STID as 
         IV110_36_0_, invtxn0_.rowid as rowid111_36_0_, invtxn0_.EN_ID as 
         EN112_36_0_, invtxn0_.STE_ID as STE113_36_0_, invtxn0_.MTH_SETID as 
         MTH114_36_0_, invtxn0_.CS_ID as CS115_36_0_, invtxn0_.IV_TYPE as 
         IV116_36_0_, csthdr1_.CS_PID as CS2_22_1_, csthdr1_.CS_NAME as 
         CS3_22_1_, csthdr1_.CS_ACTIVE as CS4_22_1_, csthdr1_.CS_ALIAS as 
         CS5_22_1_, csthdr1_.CS_REF1 as CS6_22_1_, csthdr1_.CS_REF2 as 
         CS7_22_1_, csthdr1_.CS_OREF as CS8_22_1_, csthdr1_.CS_OSUPP as 
         CS9_22_1_, csthdr1_.CS_CDSCT as CS10_22_1_, csthdr1_.CS_DELM as 
         CS11_22_1_, csthdr1_.CS_SLPN as CS12_22_1_, csthdr1_.CS_RESP as 
         CS13_22_1_, csthdr1_.CS_VATC as CS14_22_1_, csthdr1_.CS_CURR as 
         CS15_22_1_, csthdr1_.CS_XCHTPE as CS16_22_1_, csthdr1_.CS_DTEFRM as 
         CS17_22_1_, csthdr1_.CS_PAYR as CS18_22_1_, csthdr1_.CS_STATS as 
         CS19_22_1_, csthdr1_.CS_CRLM1 as CS20_22_1_, csthdr1_.CS_CRLM2 as 
         CS21_22_1_, csthdr1_.CS_CRLM3 as CS22_22_1_, csthdr1_.CS_STOP as 
         CS23_22_1_, csthdr1_.CS_OSINAMT as CS24_22_1_, csthdr1_.CS_ODINAMT as 
         CS25_22_1_, csthdr1_.CS_LINVDTE as CS26_22_1_, csthdr1_.CS_EDTE as 
         CS27_22_1_, csthdr1_.CS_SUMINV as CS28_22_1_, csthdr1_.CS_INTINV as 
         CS29_22_1_, csthdr1_.CS_INTRUL as CS30_22_1_, csthdr1_.CS_CRATING as 
         CS31_22_1_, csthdr1_.CS_CREVIEW as CS32_22_1_, csthdr1_.CS_CRUPDTE as 
         CS33_22_1_, csthdr1_.CS_DB as CS34_22_1_, csthdr1_.CS_LANG as 
         CS35_22_1_, csthdr1_.CS_PSTID as CS36_22_1_, csthdr1_.CS_REGION as 
         CS37_22_1_, csthdr1_.CS_RMKS as CS38_22_1_, csthdr1_.CS_STMT as 
         CS39_22_1_, csthdr1_.CS_CRTDBY as CS40_22_1_, csthdr1_.CS_MODBY as 
         CS41_22_1_, csthdr1_.CS_CRTDDT as CS42_22_1_, csthdr1_.CS_MODDT as 
         CS43_22_1_, csthdr1_.CS_CSGID as CS44_22_1_, csthdr1_.EN_ID as 
         EN45_22_1_, csthdr1_.STE_ID as STE46_22_1_, csthdr1_.CS_STR1 as 
         CS47_22_1_, csthdr1_.CS_STR2 as CS48_22_1_, csthdr1_.CS_STR3 as 
         CS49_22_1_, csthdr1_.CS_STR4 as CS50_22_1_, csthdr1_.CS_STR5 as 
         CS51_22_1_, csthdr1_.CS_STR6 as CS52_22_1_, csthdr1_.CS_STR7 as 
         CS53_22_1_, csthdr1_.CS_STR8 as CS54_22_1_, csthdr1_.CS_STR9 as 
         CS55_22_1_, csthdr1_.CS_STR10 as CS56_22_1_, csthdr1_.CS_STR11 as 
         CS57_22_1_, csthdr1_.CS_STR12 as CS58_22_1_, csthdr1_.CS_STR13 as 
         CS59_22_1_, csthdr1_.CS_STR14 as CS60_22_1_, csthdr1_.CS_STR15 as 
         CS61_22_1_, csthdr1_.CS_STR16 as CS62_22_1_, csthdr1_.CS_STR17 as 
         CS63_22_1_, csthdr1_.CS_STR18 as CS64_22_1_, csthdr1_.CS_STR19 as 
         CS65_22_1_, csthdr1_.CS_STR20 as CS66_22_1_, csthdr1_.CS_STR21 as 
         CS67_22_1_, csthdr1_.CS_STR22 as CS68_22_1_, csthdr1_.CS_STR23 as 
         CS69_22_1_, csthdr1_.CS_STR24 as CS70_22_1_, csthdr1_.CS_STR25 as 
         CS71_22_1_, csthdr1_.CS_NUM1 as CS72_22_1_, csthdr1_.CS_NUM2 as 
         CS73_22_1_, csthdr1_.CS_NUM3 as CS74_22_1_, csthdr1_.CS_NUM4 as 
         CS75_22_1_, csthdr1_.CS_NUM5 as CS76_22_1_, csthdr1_.CS_NUM6 as 
         CS77_22_1_, csthdr1_.CS_NUM7 as CS78_22_1_, csthdr1_.CS_NUM8 as 
         CS79_22_1_, csthdr1_.CS_NUM9 as CS80_22_1_, csthdr1_.CS_NUM10 as 
         CS81_22_1_, csthdr1_.CS_NUM11 as CS82_22_1_, csthdr1_.CS_NUM12 as 
         CS83_22_1_, csthdr1_.CS_NUM13 as CS84_22_1_, csthdr1_.CS_NUM14 as 
         CS85_22_1_, csthdr1_.CS_NUM15 as CS86_22_1_, csthdr1_.CS_NUM16 as 
         CS87_22_1_, csthdr1_.CS_NUM17 as CS88_22_1_, csthdr1_.CS_NUM18 as 
         CS89_22_1_, csthdr1_.CS_NUM19 as CS90_22_1_, csthdr1_.CS_NUM20 as 
         CS91_22_1_, csthdr1_.CS_DATE1 as CS92_22_1_, csthdr1_.CS_DATE2 as 
         CS93_22_1_, csthdr1_.CS_DATE3 as CS94_22_1_, csthdr1_.CS_DATE4 as 
         CS95_22_1_, csthdr1_.CS_DATE5 as CS96_22_1_, csthdr1_.CS_DATE6 as 
         CS97_22_1_, csthdr1_.CS_DATE7 as CS98_22_1_, csthdr1_.CS_DATE8 as 
         CS99_22_1_, csthdr1_.CS_DATE9 as CS100_22_1_, csthdr1_.CS_DATE10 as 
         CS101_22_1_, csthdr1_.CS_TERMS as CS102_22_1_, csthdr1_.CS_KEYMARK as 
         CS103_22_1_, csthdr1_.AID as AID22_1_, csthdr1_.CS_IND as 
         CS105_22_1_, csthdr1_.CS_URL as CS106_22_1_, csthdr1_.AC_TYPE as 
         AC107_22_1_, csthdr1_.CS_AVGDP as CS108_22_1_, csthdr1_.CS_BKT12 as 
         CS109_22_1_, csthdr1_.CS_ERAM as CS110_22_1_, csthdr1_.rowid as 
         rowid111_22_1_, csthdr1_.PY_CODE as PY112_22_1_, csthdr1_.PC_ID as 
         PC113_22_1_, csthdr1_.CY_ID as CY114_22_1_, csthdr1_.PR_ID as 
         PR115_22_1_, csthdr1_.CS_TYPE as CS116_22_1_, csthdr1_.DT_ID as 
         DT117_22_1_, accrtxn2_.SB_ID as SB3_1_2_, accrtxn2_.AR_BTHDTE as 
         AR4_1_2_, accrtxn2_.AR_PAYR as AR5_1_2_, accrtxn2_.AR_INVVNS as 
         AR6_1_2_, accrtxn2_.AR_INVVNO as AR7_1_2_, accrtxn2_.AR_DESC as 
         AR8_1_2_, accrtxn2_.AR_SLSPRN as AR9_1_2_, accrtxn2_.AR_CUSGRP as 
         AR10_1_2_, accrtxn2_.AR_XCHRTPE as AR11_1_2_, accrtxn2_.AR_XCHRTE as 
         AR12_1_2_, accrtxn2_.AR_FCURAMT as AR13_1_2_, accrtxn2_.AR_VATAMT as 
         AR14_1_2_, accrtxn2_.AR_CHGTPE as AR15_1_2_, accrtxn2_.AR_MRKUP as 
         AR16_1_2_, accrtxn2_.AR_FWUDTE as AR17_1_2_, accrtxn2_.AR_ACCDTE as 
         AR18_1_2_, accrtxn2_.ACC_CODE as ACC19_1_2_, accrtxn2_.AR_BANK as 
         AR20_1_2_, accrtxn2_.AR_CDSCT as AR21_1_2_, accrtxn2_.AR_PYTMTD as 
         AR22_1_2_, accrtxn2_.AR_RECCDE as AR23_1_2_, accrtxn2_.AR_RECDTE as 
         AR24_1_2_, accrtxn2_.AR_ADVCDE as AR25_1_2_, accrtxn2_.AR_PYREM as 
         AR26_1_2_, accrtxn2_.AR_LREMDTE as AR27_1_2_, accrtxn2_.AR_PTREMDTE 
         as AR28_1_2_, accrtxn2_.AR_STPBY as AR29_1_2_, accrtxn2_.AR_STPDTE as 
         AR30_1_2_, accrtxn2_.AR_NOPYTRM as AR31_1_2_, accrtxn2_.AR_INTINVB as 
         AR32_1_2_, accrtxn2_.AR_INTINVS as AR33_1_2_, accrtxn2_.AR_CINTAMT as 
         AR34_1_2_, accrtxn2_.AR_FLGCDE as AR35_1_2_, accrtxn2_.AR_GPINDTE as 
         AR36_1_2_, accrtxn2_.AR_TXT as AR37_1_2_, accrtxn2_.AR_DOCLNK as 
         AR38_1_2_, accrtxn2_.AR_DRTPRD as AR39_1_2_, accrtxn2_.AR_DRPRDTE as 
         AR40_1_2_, accrtxn2_.AR_PRODGRP as AR41_1_2_, accrtxn2_.AR_ORDNO as 
         AR42_1_2_, accrtxn2_.AR_TXNDTE as AR43_1_2_, accrtxn2_.AR_FRTTRM as 
         AR44_1_2_, accrtxn2_.AR_NBR as AR45_1_2_, accrtxn2_.AR_PRINT as 
         AR46_1_2_, accrtxn2_.AR_CRTDBY as AR47_1_2_, accrtxn2_.AR_MODBY as 
         AR48_1_2_, accrtxn2_.AR_CRTDDT as AR49_1_2_, accrtxn2_.AR_MODDT as 
         AR50_1_2_, accrtxn2_.EN_ID as EN51_1_2_, accrtxn2_.STE_ID as 
         STE52_1_2_, accrtxn2_.AR_AMT as AR53_1_2_, accrtxn2_.AR_OUTAMT as 
         AR54_1_2_, accrtxn2_.AR_STR1 as AR55_1_2_, accrtxn2_.AR_STR2 as 
         AR56_1_2_, accrtxn2_.AR_STR3 as AR57_1_2_, accrtxn2_.AR_STR4 as 
         AR58_1_2_, accrtxn2_.AR_STR5 as AR59_1_2_, accrtxn2_.AR_STR6 as 
         AR60_1_2_, accrtxn2_.AR_STR7 as AR61_1_2_, accrtxn2_.AR_STR8 as 
         AR62_1_2_, accrtxn2_.AR_STR9 as AR63_1_2_, accrtxn2_.AR_STR10 as 
         AR64_1_2_, accrtxn2_.AR_STR11 as AR65_1_2_, accrtxn2_.AR_STR12 as 
         AR66_1_2_, accrtxn2_.AR_STR13 as AR67_1_2_, accrtxn2_.AR_STR14 as 
         AR68_1_2_, accrtxn2_.AR_STR15 as AR69_1_2_, accrtxn2_.AR_NUM1 as 
         AR70_1_2_, accrtxn2_.AR_NUM2 as AR71_1_2_, accrtxn2_.AR_NUM3 as 
         AR72_1_2_, accrtxn2_.AR_NUM4 as AR73_1_2_, accrtxn2_.AR_NUM5 as 
         AR74_1_2_, accrtxn2_.AR_NUM6 as AR75_1_2_, accrtxn2_.AR_NUM7 as 
         AR76_1_2_, accrtxn2_.AR_NUM8 as AR77_1_2_, accrtxn2_.AR_NUM9 as 
         AR78_1_2_, accrtxn2_.AR_NUM10 as AR79_1_2_, accrtxn2_.AR_DATE1 as 
         AR80_1_2_, accrtxn2_.AR_DATE2 as AR81_1_2_, accrtxn2_.AR_DATE3 as 
         AR82_1_2_, accrtxn2_.AR_DATE4 as AR83_1_2_, accrtxn2_.AR_DATE5 as 
         AR84_1_2_, accrtxn2_.AR_DATE6 as AR85_1_2_, accrtxn2_.AR_DATE7 as 
         AR86_1_2_, accrtxn2_.AR_DATE8 as AR87_1_2_, accrtxn2_.AR_DATE9 as 
         AR88_1_2_, accrtxn2_.AR_DATE10 as AR89_1_2_, accrtxn2_.AR_PROMDTE as 
         AR90_1_2_, accrtxn2_.TID as TID1_2_, accrtxn2_.PY_TERMS as PY92_1_2_, 
         accrtxn2_.PR_ID as PR93_1_2_ from INV_TXN invtxn0_, CST_HDR csthdr1_, 
         ACCR_TXN accrtxn2_, CSTPE_HDR cstpehdr4_ where 
         invtxn0_.CS_ID=csthdr1_.CS_ID(+) and 
         invtxn0_.IV_ID=accrtxn2_.IV_ID(+) and 
         invtxn0_.IV_DATE=accrtxn2_.IV_DATE(+) and 
         csthdr1_.CS_TYPE=cstpehdr4_.CS_TYPE and (invtxn0_.CS_ID in (:1 , :2 , 
         :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 
         , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , 
         :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 
         , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 
         :50)) and invtxn0_.IV_TYPE=cstpehdr4_.CS_NAME and 
         invtxn0_.IV_CLOSED=0
      RATIONALE: SQL statement with SQL_ID "4fx1nsvwwbgm8" was executed 319 
         times and had an average elapsed time of 79 seconds.
      RATIONALE: Waiting for event "db file sequential read" in wait class 
         "User I/O" accounted for 38% of the database time spent in processing 
         the SQL statement with SQL_ID "4fx1nsvwwbgm8".
      RATIONALE: Waiting for event "read by other session" in wait class "User 
         I/O" accounted for 20% of the database time spent in processing the 
         SQL statement with SQL_ID "4fx1nsvwwbgm8".
      RATIONALE: Waiting for event "gc buffer busy" in wait class "Cluster" 
         accounted for 18% of the database time spent in processing the SQL 
         statement with SQL_ID "4fx1nsvwwbgm8".
      RATIONALE: Average time spent in User I/O wait events per execution was 
         57 seconds.
 
   RECOMMENDATION 2: SQL Tuning, 6.1% benefit (25058 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "fmn7h9fupj823".
         RELEVANT OBJECT: SQL statement with SQL_ID fmn7h9fupj823 and 
         PLAN_HASH 1910842901
         DELETE FROM CST_HDR where en_id=3940
      RATIONALE: SQL statement with SQL_ID "fmn7h9fupj823" was executed 1 
         times and had an average elapsed time of 24968 seconds.
      RATIONALE: Average time spent in User I/O wait events per execution was 
         24020 seconds.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (19% impact [75802 seconds])
 
FINDING 7: 5.2% impact (21277 seconds)
--------------------------------------
The SGA was inadequately sized, causing additional I/O or hard parses.
 
   RECOMMENDATION 1: DB Configuration, 5.2% benefit (21277 seconds)
      ACTION: Increase the size of the SGA by setting the parameter 
         "sga_target" to 7680 M.
 
   ADDITIONAL INFORMATION:
      The value of parameter "sga_target" was "3840 M" during the analysis 
      period.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Hard parsing of SQL statements was consuming significant 
               database time. (46% impact [186603 seconds])
         SYMPTOM: Contention for latches related to the shared pool was 
                  consuming significant database time. (45% impact [183373 
                  seconds])
            INFO: Waits for "library cache lock" amounted to 28% of database 
                  time.
                  Waits for "cursor: pin S wait on X" amounted to 16% of 
                  database time.
            SYMPTOM: Wait class "Concurrency" was consuming significant 
                     database time. (45% impact [183457 seconds])
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (19% impact [75802 seconds])
 
FINDING 8: 3.9% impact (16042 seconds)
--------------------------------------
The throughput of the I/O subsystem was significantly lower than expected.
 
   RECOMMENDATION 1: Host Configuration, 3.9% benefit (16042 seconds)
      ACTION: Consider increasing the throughput of the I/O subsystem. 
         Oracle's recommended solution is to stripe all data file using the 
         SAME methodology. You might also need to increase the number of disks 
         for better performance. Alternatively, consider using Oracle's 
         Automatic Storage Management solution.
      RATIONALE: During the analysis period, the average data files' I/O 
         throughput was 3.9 M per second for reads and 26 K per second for 
         writes. The average response time for single block reads was 15 
         milliseconds.
 
   RECOMMENDATION 2: Host Configuration, 2.9% benefit (11871 seconds)
      ACTION: The performance of file +DATA/capgent/capgent_data.dbf was 
         significantly worse than other files. If striping all files using the 
         SAME methodology is not possible, consider striping this file over 
         multiple disks.
         RELEVANT OBJECT: database file
         "+DATA/capgent/capgent_data.dbf"
      RATIONALE: The average response time for single block reads for this 
         file was 13 milliseconds.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (19% impact [75802 seconds])
 
FINDING 9: 2.4% impact (9670 seconds)
-------------------------------------
Read and write contention on database blocks was consuming significant 
database time.
 
   NO RECOMMENDATIONS AVAILABLE
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "Concurrency" was consuming significant database 
               time. (45% impact [183457 seconds])
      SYMPTOM: Inter-instance messaging was consuming significant database 
               time on this instance. (3.5% impact [14428 seconds])
         SYMPTOM: Wait class "Cluster" was consuming significant database 
                  time. (3.6% impact [14523 seconds])
 
FINDING 10: 2.3% impact (9379 seconds)
--------------------------------------
SQL statements were found waiting for row lock waits.
 
   RECOMMENDATION 1: Application Analysis, 1.7% benefit (7032 seconds)
      ACTION: Significant row contention was detected in the TABLE 
         "DNBI.STS_LOG" with object id 56506. Trace the cause of row 
         contention in the application logic using the given blocked SQL.
         RELEVANT OBJECT: database object with id 56506
      RATIONALE: The SQL statement with SQL_ID "frz0mh8y2abxu" was blocked on 
         row locks.
         RELEVANT OBJECT: SQL statement with SQL_ID frz0mh8y2abxu
         update STS_LOG set ST_IDT1=:1, ST_IDT2=:2, ST_TXNTPE=:3, ST_DESC=:4, 
         ST_CRTDBY=:5, ST_MODBY=:6, ST_CRTDDT=:7, ST_MODDT=:8, ST_ISCURR=:9, 
         EN_ID=:10, STE_ID=:11, TID=:12, AID=:13, ST_ID=:14, IV_ID=:15, 
         IV_DATE=:16, CS_ID=:17 where LOG_ID=:18
 
   RECOMMENDATION 2: Application Analysis, 0.57% benefit (2347 seconds)
      ACTION: Significant row contention was detected in the TABLE 
         "DNBI.CST_AGEHDR" with object id 99805. Trace the cause of row 
         contention in the application logic using the given blocked SQL.
         RELEVANT OBJECT: database object with id 99805
      RATIONALE: The SQL statement with SQL_ID "6af8watws5dww" was blocked on 
         row locks.
         RELEVANT OBJECT: SQL statement with SQL_ID 6af8watws5dww
         DELETE FROM CST_AGEHDR WHERE CS_ID IN (SELECT CS_ID FROM CST_HDR 
         WHERE EN_ID=3940)
      RATIONALE: Session with ID "277", User ID "65", Program "SQL Developer" 
         and Module "SQL Developer" was the blocking session responsible for 
         100% of this recommendation's benefit.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "Application" was consuming significant database 
               time. (2.4% impact [9763 seconds])
 
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
          ADDITIONAL INFORMATION
          ----------------------
 
Wait class "Commit" was not consuming significant database time.
Wait class "Configuration" was not consuming significant database time.
CPU was not a bottleneck for the instance.
Wait class "Network" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database 
time.
 
The database's maintenance windows were active during 49% of the analysis 
period.
 
The analysis of I/O performance is based on the default assumption that the 
average read time for one database block is 10000 micro-seconds.
 
An explanation of the terminology used in this report is available when you 
run the report with the 'ALL' level of detail.