DETAILED ADDM REPORT FOR TASK 'TASK_67242' WITH ID 67242
          --------------------------------------------------------
 
              Analysis Period: from 24-MAR-2011 18:00 to 25-MAR-2011 13:00
         Database ID/Instance: 3184325432/1
      Database/Instance Names: ORASP/ORASP1
                    Host Name: prvrac0.provade.com
             Database Version: 10.2.0.4.0
               Snapshot Range: from 13 to 32
                Database Time: 7529 seconds
        Average Database Load: .1 active sessions
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
 
FINDING 1: 40% impact (3022 seconds)
------------------------------------
SQL statements consuming significant database time were found.
 
   RECOMMENDATION 1: SQL Tuning, 11% benefit (802 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "5gp0520qnhgrb".
         RELEVANT OBJECT: SQL statement with SQL_ID 5gp0520qnhgrb and 
         PLAN_HASH 3481439974
         SELECT DISTINCT (PROCESSID) FROM PSAPMSGPUBHDR WHERE MACHINENAME=:1 
         AND PUBSTATUS IN (2, 3) ORDER BY PROCESSID
      RATIONALE: SQL statement with SQL_ID "5gp0520qnhgrb" was executed 4484 
         times and had an average elapsed time of 0.17 seconds.
 
   RECOMMENDATION 2: SQL Tuning, 9.5% benefit (719 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "guzwc8j822kdj".
         RELEVANT OBJECT: SQL statement with SQL_ID guzwc8j822kdj and 
         PLAN_HASH 596449295
         select distinct T7396.BUSINESS_UNIT as c1,
         T7396.TIME_SHEET_ID as c2,
         TRUNC(T7363.SUBMISSION_DATE) as c3,
         T8381.XLATLONGNAME as c4,
         T7363.TIME_HDR_STATUS as c5,
         TRUNC(T11231.DATETIME_STAMP) as c6,
         T11231.NAME_DISPLAY as c7,
         T9789.OPRDEFNDESC as c8,
         T9789.EMAILID as c9,
         concat('C', cast(T11106.PRV_EIN as  CHARACTER ( 30 ) )) as c10,
         T5144.PERSON_ID as c11,
         T5144.NAME as c12,
         T5144.FIRST_NAME as c13,
         T5144.MIDDLE_NAME as c14,
         T5144.LAST_NAME as c15,
         T7435.DATE_UNDER_RPT as c16,
         T8160.WO_RATE * (T10408.SP_MSP_PERCENT / nullif( 100, 0) + 1) as c17,
         case  when T7435.TRC in ('DDT20', 'DOT', 'OD135', 'OVT', 'OW125', 
         'OW135') then T7983.FACTOR_MULT * T8160.WO_RATE * 
         (T10408.SP_MSP_PERCENT / nullif( 100, 0) + 1) else 0 end  as c18,
         case  when T7435.TRC in ('DD165') then T7983.FACTOR_MULT * 
         T8160.WO_RATE * (T10408.SP_MSP_PERCENT / nullif( 100, 0) + 1) else 0 
         end  as c19,
         T7435.SP_TIME_QTY as c20,
         T7435.TIME_AMOUNT as c21,
         T7396.SP_TIME_QTY as c22,
         T7396.TIME_AMOUNT as c23,
         TRUNC(T7363.PERIOD_START_DT) as c24,
         TRUNC(T7363.PERIOD_END_DT) as c25,
         T8160.PO_ID as c26,
         T5204.DESCR as c27,
         T11112.DESCR as c28,
         T8160.WORK_ORDER_ID as c29,
         TRUNC(T8160.RATE_EFFDT) as c30,
         T6648.DESCR as c31,
         T6648.LOCATION as c32,
         T5090.DESCR as c33,
         T5090.DEPTID as c34,
         T5101.NAME1 as c35,
         T5101.VENDOR_ID as c36,
         T8160.CURRENCY_CD as c37,
         T7424.SPA_START_TIME as c38,
         T7424.SPA_STOP_TIME as c39,
         TRUNC(T8160.ACT_START_DT) as c40,
         TRUNC(T8160.END_DATE) as c41
         from 
         (
         (
         (
         PS_SPA_TM_DTL_HRLY T7435 /* F_SPA_TM_DTL_HRLY */  inner join (
         PS_SPA_TIM_DTL_DLY T7424 /* F_SPA_TIM_DTL_DLY */  left outer join (
         (
         (
         (
         (
         (
         (
         PS_PRV_SRVCP_SP_VW T5144 /* D_SERVICE_PROVIDER */  left outer join 
         PS_PRV_SERVICE_PRV T11106 /* F_PRV_SERVICE_PRV */  On T5144.PERSON_ID 
         = T11106.PERSON_ID) left outer join PS_PRV_HIRE_VW T11109 /* 
         F_PRV_HIRE_VW */  On T5144.PERSON_ID = T11109.PERSON_ID) inner join (
         (
         (
         (
         (
         (
         (
         PS_PRV_WO_TMAMT_VW T8160 /* F_SERVICES_MGMT */  left outer join 
         PS_PRV_PROJECT_VW T5097 /* D_ACCT_PROJECT */  On T5097.BUSINESS_UNIT 
         = T8160.BUSINESS_UNIT and T5097.PROJECT_ID = T8160.PROJECT_ID) left 
         outer join PS_PRV_WORDERREC T10388 /* F_PRV_WORDERREC */  On 
         T8160.BUSINESS_UNIT = T10388.BUSINESS_UNIT and T8160.WORK_ORDER_ID = 
         T10388.WORK_ORDER_ID) left outer join PSOPRDEFN T9903 /* 
         F_PRV_EXPENSE_APPROVER_EMAIL */  On T8160.SP_EXP_APPROVER = 
         T9903.OPRID) left outer join PSOPRDEFN T9789 /* 
         F_PRV_TIMESHEET_APPROVER_EMAIL */  On T8160.TE_APPROVER = 
         T9789.OPRID) inner join (
         PS_PRV_DEPT_SP_VW T5090 /* D_DEPARTMENT */  left outer join 
         PS_SEC_BU_OPR T10522 /* D_SEC_BU_OPR */  On T5090.BUSINESS_UNIT = 
         T10522.BUSINESS_UNIT) On T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT and 
         T5090.BUSINESS_UNIT = T8160.BUSINESS_UNIT and T5090.DEPTID = 
         T8160.DEPTID) inner join PS_PRV_LCTN_SP_VW T6648 /* D_LOCATION */  On 
         T6648.BUSINESS_UNIT = T8160.BUSINESS_UNIT and T6648.BUSINESS_UNIT = 
         T10522.BUSINESS_UNIT and T6648.LOCATION = T8160.LOCATION) inner join 
         PS_PRV_VNDR_SP_VW T5101 /* D_SUPPLIER */  On T5101.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T5101.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T5101.VENDOR_ID = T8160.VENDOR_ID) On T5144.PERSON_ID = 
         T8160.WO_CONID and T5144.BUSINESS_UNIT = T8160.BUSINESS_UNIT and 
         T5144.BUSINESS_UNIT = T10522.BUSINESS_UNIT) inner join 
         PS_PRV_SRVCS_SP_VW T5204 /* D_SERVICE */  On T5204.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T5204.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T5204.PROJ_ROLE = T8160.PROJ_ROLE) inner join PS_PRV_SRVC_SP_VW 
         T11112 /* D_SERVICE_TYPE */  On T8160.BUSINESS_UNIT = 
         T11112.BUSINESS_UNIT and T8160.ROLE_TYPE = T11112.ROLE_TYPE and 
         T10522.BUSINESS_UNIT = T11112.BUSINESS_UNIT) inner join 
         PS_PRV_VND_STAT_VW T9532 /* F_PRV_VND_STAT_VW */  On 
         T5101.VENDOR_STATUS = T9532.FIELDVALUE) inner join PS_SPB_PERS_EMAIL 
         T9898 /* D_SERVICE_PROVD_EMAIL */  On T5144.PERSON_ID = 
         T9898.PERSON_ID) On T7424.BUSINESS_UNIT = T8160.BUSINESS_UNIT and 
         T7424.WORK_ORDER_ID = T8160.WORK_ORDER_ID) On T7435.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7435.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T7435.WORK_ORDER_ID = T8160.WORK_ORDER_ID) inner join 
         PS_SPB_OT_TRC_VW T7983 /* F_SPB_OT_TRC_VW */  On T7435.TRC = 
         T7983.TRC) left outer join 
         PS_SPB_VMS_INFO_SR T10408 /* F_SPB_VMS_INFO_SR */  On 
         T8160.BUSINESS_UNIT = T10408.BUSINESS_UNIT and T8160.ROLE_TYPE = 
         T10408.ROLE_TYPE and T8160.VMS_LOCATION = T10408.VMS_LOCATION and 
         T8160.VMS_SUPPLIER_ID = T10408.VMS_SUPPLIER_ID) left outer join (
         (
         (
         PS_SPA_TIME_DTL T7396 /* F_SPA_TIME_DTL */  left outer join 
         PS_PRV_ACTVT_SP_VW T7684 /* D_ACTIVITY */  On T7396.BUSINESS_UNIT = 
         T7684.BUSINESS_UNIT and T7396.ACTIVITY_ID = T7684.ACTIVITY_ID) left 
         outer join PS_PRV_TIMHIST_APR T11231 /* F_PRV_TIMHIST_APR_SERVICES */ 
         On T7396.BUSINESS_UNIT = T11231.BUSINESS_UNIT and T7396.TIME_SHEET_ID 
         = T11231.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11231.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11231.LINE_NBR) left outer join 
         PS_PRV_TIMHIST_DEN T11238 /* F_PRV_TIMHIST_DEN_SERVICES */  On 
         T7396.BUSINESS_UNIT = T11238.BUSINESS_UNIT and T7396.TIME_SHEET_ID = 
         T11238.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11238.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11238.LINE_NBR) On T7396.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7396.WORK_ORDER_ID = T8160.WORK_ORDER_ID,
         PS_SPA_TIME_HDR T7363 /* F_SPA_TIME_HDR */ ,
         PS_PRV_TIME_STS_VW T8381 /* D_XLAT_TIME_HDR_STATUS */ 
         where  ( T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT )  and  ( 
         T7363.BUSINESS_UNIT = T7396.BUSINESS_UNIT and T7363.TIME_SHEET_ID = 
         T7396.TIME_SHEET_ID and T7363.TIME_HDR_STATUS = T8381.FIELDVALUE and 
         T7396.BUSINESS_UNIT = T10522.BUSINESS_UNIT and T7396.BUSINESS_UNIT = 
         'MOUSA' and T9789.OPRID = T11231.NAME_DISPLAY and T9898.PRIMARY_FLAG 
         = 'Y' and T10522.OPRID = 'KADELFS' and (T8381.XLATLONGNAME in 
         ('Approved', 'Submitted')) and  TRUNC(T11231.DATETIME_STAMP) between 
         TO_DATE('2011-03-01' , 'YYYY-MM-DD') and TO_DATE('2011-03-24' , 
         'YYYY-MM-DD') ) 
         order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, 
         c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, 
         c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41
      RATIONALE: SQL statement with SQL_ID "guzwc8j822kdj" was executed 1 
         times and had an average elapsed time of 710 seconds.
 
   RECOMMENDATION 3: SQL Tuning, 8.3% benefit (626 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "2my8a2bjvdmyz".
         RELEVANT OBJECT: SQL statement with SQL_ID 2my8a2bjvdmyz and 
         PLAN_HASH 1442702467
         SELECT R.PRCSINSTANCE ,R.ORIGPRCSINSTANCE 
         ,R.RECURORIGPRCSINST,R.MAINJOBINSTANCE ,R.PRCSJOBSEQ ,R.PRCSJOBNAME 
         ,R.PRCSNAME ,R.PRCSTYPE ,R.RECURNAME ,R.TIMEZONE FROM PSPRCSQUE R 
         ,PS_PRCSRECUR S WHERE ((R.RUNSTATUS IN ('9', '17')  AND 
         S.INITIATEWHEN = 1) OR   (R.RUNSTATUS IN ('3','6', '7', 
         '9','10','12', '17')  AND S.INITIATEWHEN = 0))  AND R.INITIATEDNEXT = 
         0  AND R.RUNLOCATION = '2'  AND R.RECURNAME <> ' '  AND R.PRCSJOBSEQ 
         = 0  AND R.RECURNAME = S.RECURNAME
      RATIONALE: SQL statement with SQL_ID "2my8a2bjvdmyz" was executed 4481 
         times and had an average elapsed time of 0.13 seconds.
 
   RECOMMENDATION 4: SQL Tuning, 6.4% benefit (483 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "dd48205kfvw5v".
         RELEVANT OBJECT: SQL statement with SQL_ID dd48205kfvw5v and 
         PLAN_HASH 3595265136
         select distinct T3880.BUSINESS_UNIT as c1,
         T3933.NAME as c2,
         T3895.NAME1 as c3,
         T5963.PO_ID as c4,
         T5963.WORK_ORDER_ID as c5,
         T6258.PLOG_ID as c6,
         T9100.NAME as c7,
         T6258.QUANTITY as c8,
         T6258.PL_RATE as c9,
         T9112.DESCR as c10,
         T6907.XLATLONGNAME as c11,
         T6258.SP_BILL_AMOUNT as c12
         from 
         (
         (
         (
         (
         (
         (
         (
         (
         PS_PRV_INV_TAMT_VW T5963 /* F_SPF_INVOICE_DTL */  left outer join 
         PS_PRV_INVHIST_CAN T7450 /* F_PRV_INVHIST_CAN */  On 
         T5963.BUSINESS_UNIT = T7450.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T7450.INVOICE_ID and T5963.INVOICE_LINE = T7450.INVOICE_LINE) left 
         outer join PS_PRV_INVHIST_APR T7444 /* F_PRV_INVHIST_APR */  On 
         T5963.BUSINESS_UNIT = T7444.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T7444.INVOICE_ID and T5963.INVOICE_LINE = T7444.INVOICE_LINE) left 
         outer join PS_PRV_ADDL_INV_VW T9176 /* F_PRV_ADDL_INV_VW */  On 
         T5963.BUSINESS_UNIT = T9176.BUSINESS_UNIT) left outer join 
         PS_PRV_STDID_B_NUM T9193 /* F_PRV_STDID_B_NUM */  On 
         T5963.BUSINESS_UNIT = T9193.BUSINESS_UNIT) left outer join 
         PS_PRV_STDID_R_NUM T9198 /* F_PRV_STDID_R_NUM */  On 
         T5963.BUSINESS_UNIT = T9198.BUSINESS_UNIT) left outer join 
         PS_SPF_WO_TAX T8144 /* F_PRV_SPF_WO_TAX */  On T5963.BUSINESS_UNIT = 
         T8144.BUSINESS_UNIT and T5963.WORK_ORDER_ID = T8144.WORK_ORDER_ID) 
         left outer join PSOPRDEFN T8433 /* F_PRV_INVOICE_APPROVER_EMAIL */  
         On trim(trailing ' ' from T7444.NAME_DISPLAY) = trim(trailing ' ' 
         from T8433.OPRDEFNDESC)) left outer join PS_PRV_LCTN_SP_VW T9117 /* 
         D_BILL_TO_LOCATION */  On T9117.BUSINESS_UNIT = T9176.BUSINESS_UNIT 
         and T9117.LOCATION = T9176.PRV_RECIPIENT_LOC) left outer join 
         PS_PRV_LCTN_SP_VW T9133 /* D_REMIT_TO_LOCATION */  On 
         T9133.BUSINESS_UNIT = T9176.BUSINESS_UNIT and T9133.LOCATION = 
         T9176.PRV_PAYER_LOC,
         PS_SEC_BU_OPR T9021 /* D_SEC_BU_OPR */ ,
         PS_SP_BU_SP_NONVW T3880 /* D_BUSINESS_UNIT */ ,
         (
         PS_PRV_SRVCP_SP_VW T3933 /* D_SERVICE_PROVIDER */  left outer join 
         PS_PRV_CPM_TENR_VW T7392 /* F_PRV_CPM_TENURE */  On T3933.PERSON_ID = 
         T7392.PERSON_ID and T3933.BUSINESS_UNIT = T7392.BUSINESS_UNIT) left 
         outer join PS_SPB_PERS_EMAIL T8402 /* D_SERVICE_PROVD_EMAIL */  On 
         T3933.PERSON_ID = T8402.PERSON_ID,
         (
         (
         (
         PS_PRV_VNDR_SP_VW T3895 /* D_SUPPLIER */  left outer join 
         PS_PRV_VND_SPRO_VW T8005 /* F_PRV_VND_SPRO_VW */  On 
         T3895.BUSINESS_UNIT = T8005.BUSINESS_UNIT and T3895.VENDOR_ID = 
         T8005.VENDOR_ID) left outer join PS_PRV_VNDR_PHN_VW T8041 /* 
         F_PRV_VNDR_PHN_VW */  On T3895.BUSINESS_UNIT = T8041.BUSINESS_UNIT 
         and T3895.VENDOR_ID = T8041.VENDOR_ID) left outer join 
         PS_PRV_BU_SUPP_VW T8934 /* F_PRV_BU_SUPP_VW */  On 
         T3895.BUSINESS_UNIT = T8934.BUSINESS_UNIT and T3895.VENDOR_ID = 
         T8934.VENDOR_ID) left outer join PS_PRV_VND_ETNC_VW T8857 /* 
         F_PRV_VND_ETNC_VW */  On T8005.ETHNIC_CATEGORY = T8857.FIELDVALUE,
         (
         (
         PS_SPA_PLOG_DTL T6258 /* F_SPA_PLOG_DTL */  left outer join 
         PS_PRV_PLOGACT_VW T9112 /* D_PRV_PLOGACT_VW */  On 
         T6258.BUSINESS_UNIT = T9112.BUSINESS_UNIT and T6258.ACTIVITY_ID = 
         T9112.ACTIVITY_ID and T6258.WORK_ORDER_ID = T9112.WORK_ORDER_ID) left 
         outer join PS_PRV_PLOGHST_APR T9100 /* F_PRV_PLOGHST_APR */  On 
         T6258.BUSINESS_UNIT = T9100.BUSINESS_UNIT and T6258.PLOG_ID = 
         T9100.PLOG_ID and T6258.LINE_NBR = T9100.LINE_NBR) left outer join 
         PS_PRV_PLOGHST_SUB T9106 /* F_PRV_PLOGHST_SUB */  On 
         T6258.BUSINESS_UNIT = T9106.BUSINESS_UNIT and T6258.PLOG_ID = 
         T9106.PLOG_ID and T6258.LINE_NBR = T9106.LINE_NBR,
         PS_SPA_PLOG_HDR T6247 /* F_SPA_PLOG_HDR */ ,
         PS_PRV_PLOG_STS_VW T6907 /* D_XLAT_PLOG_STATUS */ 
         where  ( T3933.PERSON_ID = T5963.WO_CONID and T3933.BUSINESS_UNIT = 
         T5963.BUSINESS_UNIT and T3933.PERSON_ID = T5963.WO_CONID and 
         T3933.BUSINESS_UNIT = T5963.BUSINESS_UNIT and T3933.PERSON_ID = 
         T5963.WO_CONID and T3933.BUSINESS_UNIT = T5963.BUSINESS_UNIT and 
         T3895.BUSINESS_UNIT = T5963.BUSINESS_UNIT and T3895.VENDOR_ID = 
         T5963.VENDOR_ID and T3895.BUSINESS_UNIT = T5963.BUSINESS_UNIT and 
         T3895.VENDOR_ID = T5963.VENDOR_ID and T3895.BUSINESS_UNIT = 
         T5963.BUSINESS_UNIT and T3895.VENDOR_ID = T5963.VENDOR_ID and 
         T5963.BUSINESS_UNIT = T6258.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T6258.INVOICE_ID and T5963.INVOICE_LINE = T6258.INVOICE_LINE and 
         T5963.BUSINESS_UNIT = T6258.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T6258.INVOICE_ID and T5963.INVOICE_LINE = T6258.INVOICE_LINE and 
         T5963.BUSINESS_UNIT = T6258.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T6258.INVOICE_ID and T5963.INVOICE_LINE = T6258.INVOICE_LINE )  and  
         ( T3895.BUSINESS_UNIT = T9021.BUSINESS_UNIT and T3933.BUSINESS_UNIT = 
         T9021.BUSINESS_UNIT and T5963.BUSINESS_UNIT = T9021.BUSINESS_UNIT and 
         T3880.BUSINESS_UNIT = T5963.BUSINESS_UNIT and T3880.BUSINESS_UNIT = 
         T9021.BUSINESS_UNIT and T6258.BUSINESS_UNIT = T9021.BUSINESS_UNIT and 
         T3933.PERSON_ID = T6247.PERSON_ID and T3933.BUSINESS_UNIT = 
         T6247.BUSINESS_UNIT and T6247.BUSINESS_UNIT = T6258.BUSINESS_UNIT and 
         T6247.PLOG_ID = T6258.PLOG_ID and T6247.PLOG_STATUS = 
         T6907.FIELDVALUE and T9021.OPRID = 'VKRISHNA' and 
         (T3880.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T3895.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T3933.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T5963.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T6907.XLATLONGNAME in ('Adjusted', 'Approved', 'Denied', 'Pending', 
         'Submitted')) ) 
         order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12
      RATIONALE: SQL statement with SQL_ID "dd48205kfvw5v" was executed 3 
         times and had an average elapsed time of 158 seconds.
 
   RECOMMENDATION 5: SQL Tuning, 5.4% benefit (405 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "7k2ff5h45f6hy".
         RELEVANT OBJECT: SQL statement with SQL_ID 7k2ff5h45f6hy and 
         PLAN_HASH 1542827345
         select distinct T7396.TIME_SHEET_ID as c1,
         TRUNC(T7363.SUBMISSION_DATE) as c2,
         T8381.XLATLONGNAME as c3,
         T7363.TIME_HDR_STATUS as c4,
         TRUNC(T11231.DATETIME_STAMP) as c5,
         T11231.NAME_DISPLAY as c6,
         T9789.EMAILID as c7,
         T7435.DATE_UNDER_RPT as c8,
         T7435.SP_TIME_QTY as c9,
         T7435.TIME_AMOUNT as c10,
         T7396.SP_TIME_QTY as c11,
         T7396.TIME_AMOUNT as c12,
         TRUNC(T7363.PERIOD_START_DT) as c13,
         TRUNC(T7363.PERIOD_END_DT) as c14,
         T7424.SPA_START_TIME as c15,
         T7424.SPA_STOP_TIME as c16,
         T8160.BUSINESS_UNIT as c17
         from 
         (
         PS_SPA_TM_DTL_HRLY T7435 /* F_SPA_TM_DTL_HRLY */  left outer join (
         PS_SPA_TIM_DTL_DLY T7424 /* F_SPA_TIM_DTL_DLY */  left outer join (
         (
         (
         (
         (
         PS_PRV_WO_TMAMT_VW T8160 /* F_SERVICES_MGMT */  left outer join 
         PS_PRV_PROJECT_VW T5097 /* D_ACCT_PROJECT */  On T5097.BUSINESS_UNIT 
         = T8160.BUSINESS_UNIT and T5097.PROJECT_ID = T8160.PROJECT_ID) left 
         outer join PS_PRV_WORDERREC T10388 /* F_PRV_WORDERREC */  On 
         T8160.BUSINESS_UNIT = T10388.BUSINESS_UNIT and T8160.WORK_ORDER_ID = 
         T10388.WORK_ORDER_ID) left outer join PSOPRDEFN T9903 /* 
         F_PRV_EXPENSE_APPROVER_EMAIL */  On T8160.SP_EXP_APPROVER = 
         T9903.OPRID) left outer join PSOPRDEFN T9789 /* 
         F_PRV_TIMESHEET_APPROVER_EMAIL */  On T8160.TE_APPROVER = 
         T9789.OPRID) inner join PS_SEC_BU_OPR T10522 /* D_SEC_BU_OPR */  On 
         T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT) On T7424.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7424.WORK_ORDER_ID = T8160.WORK_ORDER_ID) On 
         T7435.BUSINESS_UNIT = T8160.BUSINESS_UNIT and T7435.WORK_ORDER_ID = 
         T8160.WORK_ORDER_ID) left outer join (
         (
         (
         PS_SPA_TIME_DTL T7396 /* F_SPA_TIME_DTL */  left outer join 
         PS_PRV_ACTVT_SP_VW T7684 /* D_ACTIVITY */  On T7396.BUSINESS_UNIT = 
         T7684.BUSINESS_UNIT and T7396.ACTIVITY_ID = T7684.ACTIVITY_ID) left 
         outer join PS_PRV_TIMHIST_APR T11231 /* F_PRV_TIMHIST_APR_SERVICES */ 
         On T7396.BUSINESS_UNIT = T11231.BUSINESS_UNIT and T7396.TIME_SHEET_ID 
         = T11231.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11231.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11231.LINE_NBR) left outer join 
         PS_PRV_TIMHIST_DEN T11238 /* F_PRV_TIMHIST_DEN_SERVICES */  On 
         T7396.BUSINESS_UNIT = T11238.BUSINESS_UNIT and T7396.TIME_SHEET_ID = 
         T11238.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11238.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11238.LINE_NBR) On T7396.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7396.WORK_ORDER_ID = T8160.WORK_ORDER_ID,
         PS_SPA_TIME_HDR T7363 /* F_SPA_TIME_HDR */ ,
         PS_PRV_TIME_STS_VW T8381 /* D_XLAT_TIME_HDR_STATUS */ 
         where  ( T7363.BUSINESS_UNIT = T7396.BUSINESS_UNIT and 
         T7363.TIME_SHEET_ID = T7396.TIME_SHEET_ID and T7363.TIME_HDR_STATUS = 
         T8381.FIELDVALUE and T7396.BUSINESS_UNIT = T10522.BUSINESS_UNIT and 
         T7396.BUSINESS_UNIT = 'MOUSA' and T7435.BUSINESS_UNIT = 
         T10522.BUSINESS_UNIT and T9789.OPRID = T11231.NAME_DISPLAY and 
         T10522.OPRID = 'KADELFS' and (T8381.XLATLONGNAME in ('Approved', 
         'Submitted')) and  TRUNC(T11231.DATETIME_STAMP) between 
         TO_DATE('2011-03-01' , 'YYYY-MM-DD') and TO_DATE('2011-03-24' , 
         'YYYY-MM-DD') ) 
         order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, 
         c15, c16
      RATIONALE: SQL statement with SQL_ID "7k2ff5h45f6hy" was executed 1 
         times and had an average elapsed time of 405 seconds.
 
FINDING 2: 39% impact (2948 seconds)
------------------------------------
Time spent on the CPU by the instance was responsible for a substantial part 
of database time.
 
   RECOMMENDATION 1: SQL Tuning, 11% benefit (802 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "5gp0520qnhgrb".
         RELEVANT OBJECT: SQL statement with SQL_ID 5gp0520qnhgrb and 
         PLAN_HASH 3481439974
         SELECT DISTINCT (PROCESSID) FROM PSAPMSGPUBHDR WHERE MACHINENAME=:1 
         AND PUBSTATUS IN (2, 3) ORDER BY PROCESSID
      RATIONALE: SQL statement with SQL_ID "5gp0520qnhgrb" was executed 4484 
         times and had an average elapsed time of 0.17 seconds.
      RATIONALE: Average CPU used per execution was 0.17 seconds.
 
   RECOMMENDATION 2: SQL Tuning, 9.5% benefit (719 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "guzwc8j822kdj".
         RELEVANT OBJECT: SQL statement with SQL_ID guzwc8j822kdj and 
         PLAN_HASH 596449295
         select distinct T7396.BUSINESS_UNIT as c1,
         T7396.TIME_SHEET_ID as c2,
         TRUNC(T7363.SUBMISSION_DATE) as c3,
         T8381.XLATLONGNAME as c4,
         T7363.TIME_HDR_STATUS as c5,
         TRUNC(T11231.DATETIME_STAMP) as c6,
         T11231.NAME_DISPLAY as c7,
         T9789.OPRDEFNDESC as c8,
         T9789.EMAILID as c9,
         concat('C', cast(T11106.PRV_EIN as  CHARACTER ( 30 ) )) as c10,
         T5144.PERSON_ID as c11,
         T5144.NAME as c12,
         T5144.FIRST_NAME as c13,
         T5144.MIDDLE_NAME as c14,
         T5144.LAST_NAME as c15,
         T7435.DATE_UNDER_RPT as c16,
         T8160.WO_RATE * (T10408.SP_MSP_PERCENT / nullif( 100, 0) + 1) as c17,
         case  when T7435.TRC in ('DDT20', 'DOT', 'OD135', 'OVT', 'OW125', 
         'OW135') then T7983.FACTOR_MULT * T8160.WO_RATE * 
         (T10408.SP_MSP_PERCENT / nullif( 100, 0) + 1) else 0 end  as c18,
         case  when T7435.TRC in ('DD165') then T7983.FACTOR_MULT * 
         T8160.WO_RATE * (T10408.SP_MSP_PERCENT / nullif( 100, 0) + 1) else 0 
         end  as c19,
         T7435.SP_TIME_QTY as c20,
         T7435.TIME_AMOUNT as c21,
         T7396.SP_TIME_QTY as c22,
         T7396.TIME_AMOUNT as c23,
         TRUNC(T7363.PERIOD_START_DT) as c24,
         TRUNC(T7363.PERIOD_END_DT) as c25,
         T8160.PO_ID as c26,
         T5204.DESCR as c27,
         T11112.DESCR as c28,
         T8160.WORK_ORDER_ID as c29,
         TRUNC(T8160.RATE_EFFDT) as c30,
         T6648.DESCR as c31,
         T6648.LOCATION as c32,
         T5090.DESCR as c33,
         T5090.DEPTID as c34,
         T5101.NAME1 as c35,
         T5101.VENDOR_ID as c36,
         T8160.CURRENCY_CD as c37,
         T7424.SPA_START_TIME as c38,
         T7424.SPA_STOP_TIME as c39,
         TRUNC(T8160.ACT_START_DT) as c40,
         TRUNC(T8160.END_DATE) as c41
         from 
         (
         (
         (
         PS_SPA_TM_DTL_HRLY T7435 /* F_SPA_TM_DTL_HRLY */  inner join (
         PS_SPA_TIM_DTL_DLY T7424 /* F_SPA_TIM_DTL_DLY */  left outer join (
         (
         (
         (
         (
         (
         (
         PS_PRV_SRVCP_SP_VW T5144 /* D_SERVICE_PROVIDER */  left outer join 
         PS_PRV_SERVICE_PRV T11106 /* F_PRV_SERVICE_PRV */  On T5144.PERSON_ID 
         = T11106.PERSON_ID) left outer join PS_PRV_HIRE_VW T11109 /* 
         F_PRV_HIRE_VW */  On T5144.PERSON_ID = T11109.PERSON_ID) inner join (
         (
         (
         (
         (
         (
         (
         PS_PRV_WO_TMAMT_VW T8160 /* F_SERVICES_MGMT */  left outer join 
         PS_PRV_PROJECT_VW T5097 /* D_ACCT_PROJECT */  On T5097.BUSINESS_UNIT 
         = T8160.BUSINESS_UNIT and T5097.PROJECT_ID = T8160.PROJECT_ID) left 
         outer join PS_PRV_WORDERREC T10388 /* F_PRV_WORDERREC */  On 
         T8160.BUSINESS_UNIT = T10388.BUSINESS_UNIT and T8160.WORK_ORDER_ID = 
         T10388.WORK_ORDER_ID) left outer join PSOPRDEFN T9903 /* 
         F_PRV_EXPENSE_APPROVER_EMAIL */  On T8160.SP_EXP_APPROVER = 
         T9903.OPRID) left outer join PSOPRDEFN T9789 /* 
         F_PRV_TIMESHEET_APPROVER_EMAIL */  On T8160.TE_APPROVER = 
         T9789.OPRID) inner join (
         PS_PRV_DEPT_SP_VW T5090 /* D_DEPARTMENT */  left outer join 
         PS_SEC_BU_OPR T10522 /* D_SEC_BU_OPR */  On T5090.BUSINESS_UNIT = 
         T10522.BUSINESS_UNIT) On T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT and 
         T5090.BUSINESS_UNIT = T8160.BUSINESS_UNIT and T5090.DEPTID = 
         T8160.DEPTID) inner join PS_PRV_LCTN_SP_VW T6648 /* D_LOCATION */  On 
         T6648.BUSINESS_UNIT = T8160.BUSINESS_UNIT and T6648.BUSINESS_UNIT = 
         T10522.BUSINESS_UNIT and T6648.LOCATION = T8160.LOCATION) inner join 
         PS_PRV_VNDR_SP_VW T5101 /* D_SUPPLIER */  On T5101.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T5101.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T5101.VENDOR_ID = T8160.VENDOR_ID) On T5144.PERSON_ID = 
         T8160.WO_CONID and T5144.BUSINESS_UNIT = T8160.BUSINESS_UNIT and 
         T5144.BUSINESS_UNIT = T10522.BUSINESS_UNIT) inner join 
         PS_PRV_SRVCS_SP_VW T5204 /* D_SERVICE */  On T5204.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T5204.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T5204.PROJ_ROLE = T8160.PROJ_ROLE) inner join PS_PRV_SRVC_SP_VW 
         T11112 /* D_SERVICE_TYPE */  On T8160.BUSINESS_UNIT = 
         T11112.BUSINESS_UNIT and T8160.ROLE_TYPE = T11112.ROLE_TYPE and 
         T10522.BUSINESS_UNIT = T11112.BUSINESS_UNIT) inner join 
         PS_PRV_VND_STAT_VW T9532 /* F_PRV_VND_STAT_VW */  On 
         T5101.VENDOR_STATUS = T9532.FIELDVALUE) inner join PS_SPB_PERS_EMAIL 
         T9898 /* D_SERVICE_PROVD_EMAIL */  On T5144.PERSON_ID = 
         T9898.PERSON_ID) On T7424.BUSINESS_UNIT = T8160.BUSINESS_UNIT and 
         T7424.WORK_ORDER_ID = T8160.WORK_ORDER_ID) On T7435.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7435.BUSINESS_UNIT = T10522.BUSINESS_UNIT 
         and T7435.WORK_ORDER_ID = T8160.WORK_ORDER_ID) inner join 
         PS_SPB_OT_TRC_VW T7983 /* F_SPB_OT_TRC_VW */  On T7435.TRC = 
         T7983.TRC) left outer join 
         PS_SPB_VMS_INFO_SR T10408 /* F_SPB_VMS_INFO_SR */  On 
         T8160.BUSINESS_UNIT = T10408.BUSINESS_UNIT and T8160.ROLE_TYPE = 
         T10408.ROLE_TYPE and T8160.VMS_LOCATION = T10408.VMS_LOCATION and 
         T8160.VMS_SUPPLIER_ID = T10408.VMS_SUPPLIER_ID) left outer join (
         (
         (
         PS_SPA_TIME_DTL T7396 /* F_SPA_TIME_DTL */  left outer join 
         PS_PRV_ACTVT_SP_VW T7684 /* D_ACTIVITY */  On T7396.BUSINESS_UNIT = 
         T7684.BUSINESS_UNIT and T7396.ACTIVITY_ID = T7684.ACTIVITY_ID) left 
         outer join PS_PRV_TIMHIST_APR T11231 /* F_PRV_TIMHIST_APR_SERVICES */ 
         On T7396.BUSINESS_UNIT = T11231.BUSINESS_UNIT and T7396.TIME_SHEET_ID 
         = T11231.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11231.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11231.LINE_NBR) left outer join 
         PS_PRV_TIMHIST_DEN T11238 /* F_PRV_TIMHIST_DEN_SERVICES */  On 
         T7396.BUSINESS_UNIT = T11238.BUSINESS_UNIT and T7396.TIME_SHEET_ID = 
         T11238.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11238.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11238.LINE_NBR) On T7396.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7396.WORK_ORDER_ID = T8160.WORK_ORDER_ID,
         PS_SPA_TIME_HDR T7363 /* F_SPA_TIME_HDR */ ,
         PS_PRV_TIME_STS_VW T8381 /* D_XLAT_TIME_HDR_STATUS */ 
         where  ( T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT )  and  ( 
         T7363.BUSINESS_UNIT = T7396.BUSINESS_UNIT and T7363.TIME_SHEET_ID = 
         T7396.TIME_SHEET_ID and T7363.TIME_HDR_STATUS = T8381.FIELDVALUE and 
         T7396.BUSINESS_UNIT = T10522.BUSINESS_UNIT and T7396.BUSINESS_UNIT = 
         'MOUSA' and T9789.OPRID = T11231.NAME_DISPLAY and T9898.PRIMARY_FLAG 
         = 'Y' and T10522.OPRID = 'KADELFS' and (T8381.XLATLONGNAME in 
         ('Approved', 'Submitted')) and  TRUNC(T11231.DATETIME_STAMP) between 
         TO_DATE('2011-03-01' , 'YYYY-MM-DD') and TO_DATE('2011-03-24' , 
         'YYYY-MM-DD') ) 
         order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, 
         c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, 
         c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41
      RATIONALE: SQL statement with SQL_ID "guzwc8j822kdj" was executed 1 
         times and had an average elapsed time of 710 seconds.
      RATIONALE: Average CPU used per execution was 703 seconds.
 
   RECOMMENDATION 3: SQL Tuning, 8.3% benefit (626 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "2my8a2bjvdmyz".
         RELEVANT OBJECT: SQL statement with SQL_ID 2my8a2bjvdmyz and 
         PLAN_HASH 1442702467
         SELECT R.PRCSINSTANCE ,R.ORIGPRCSINSTANCE 
         ,R.RECURORIGPRCSINST,R.MAINJOBINSTANCE ,R.PRCSJOBSEQ ,R.PRCSJOBNAME 
         ,R.PRCSNAME ,R.PRCSTYPE ,R.RECURNAME ,R.TIMEZONE FROM PSPRCSQUE R 
         ,PS_PRCSRECUR S WHERE ((R.RUNSTATUS IN ('9', '17')  AND 
         S.INITIATEWHEN = 1) OR   (R.RUNSTATUS IN ('3','6', '7', 
         '9','10','12', '17')  AND S.INITIATEWHEN = 0))  AND R.INITIATEDNEXT = 
         0  AND R.RUNLOCATION = '2'  AND R.RECURNAME <> ' '  AND R.PRCSJOBSEQ 
         = 0  AND R.RECURNAME = S.RECURNAME
      RATIONALE: SQL statement with SQL_ID "2my8a2bjvdmyz" was executed 4481 
         times and had an average elapsed time of 0.13 seconds.
      RATIONALE: Average CPU used per execution was 0.13 seconds.
 
   RECOMMENDATION 4: SQL Tuning, 6.4% benefit (483 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "dd48205kfvw5v".
         RELEVANT OBJECT: SQL statement with SQL_ID dd48205kfvw5v and 
         PLAN_HASH 3595265136
         select distinct T3880.BUSINESS_UNIT as c1,
         T3933.NAME as c2,
         T3895.NAME1 as c3,
         T5963.PO_ID as c4,
         T5963.WORK_ORDER_ID as c5,
         T6258.PLOG_ID as c6,
         T9100.NAME as c7,
         T6258.QUANTITY as c8,
         T6258.PL_RATE as c9,
         T9112.DESCR as c10,
         T6907.XLATLONGNAME as c11,
         T6258.SP_BILL_AMOUNT as c12
         from 
         (
         (
         (
         (
         (
         (
         (
         (
         PS_PRV_INV_TAMT_VW T5963 /* F_SPF_INVOICE_DTL */  left outer join 
         PS_PRV_INVHIST_CAN T7450 /* F_PRV_INVHIST_CAN */  On 
         T5963.BUSINESS_UNIT = T7450.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T7450.INVOICE_ID and T5963.INVOICE_LINE = T7450.INVOICE_LINE) left 
         outer join PS_PRV_INVHIST_APR T7444 /* F_PRV_INVHIST_APR */  On 
         T5963.BUSINESS_UNIT = T7444.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T7444.INVOICE_ID and T5963.INVOICE_LINE = T7444.INVOICE_LINE) left 
         outer join PS_PRV_ADDL_INV_VW T9176 /* F_PRV_ADDL_INV_VW */  On 
         T5963.BUSINESS_UNIT = T9176.BUSINESS_UNIT) left outer join 
         PS_PRV_STDID_B_NUM T9193 /* F_PRV_STDID_B_NUM */  On 
         T5963.BUSINESS_UNIT = T9193.BUSINESS_UNIT) left outer join 
         PS_PRV_STDID_R_NUM T9198 /* F_PRV_STDID_R_NUM */  On 
         T5963.BUSINESS_UNIT = T9198.BUSINESS_UNIT) left outer join 
         PS_SPF_WO_TAX T8144 /* F_PRV_SPF_WO_TAX */  On T5963.BUSINESS_UNIT = 
         T8144.BUSINESS_UNIT and T5963.WORK_ORDER_ID = T8144.WORK_ORDER_ID) 
         left outer join PSOPRDEFN T8433 /* F_PRV_INVOICE_APPROVER_EMAIL */  
         On trim(trailing ' ' from T7444.NAME_DISPLAY) = trim(trailing ' ' 
         from T8433.OPRDEFNDESC)) left outer join PS_PRV_LCTN_SP_VW T9117 /* 
         D_BILL_TO_LOCATION */  On T9117.BUSINESS_UNIT = T9176.BUSINESS_UNIT 
         and T9117.LOCATION = T9176.PRV_RECIPIENT_LOC) left outer join 
         PS_PRV_LCTN_SP_VW T9133 /* D_REMIT_TO_LOCATION */  On 
         T9133.BUSINESS_UNIT = T9176.BUSINESS_UNIT and T9133.LOCATION = 
         T9176.PRV_PAYER_LOC,
         PS_SEC_BU_OPR T9021 /* D_SEC_BU_OPR */ ,
         PS_SP_BU_SP_NONVW T3880 /* D_BUSINESS_UNIT */ ,
         (
         PS_PRV_SRVCP_SP_VW T3933 /* D_SERVICE_PROVIDER */  left outer join 
         PS_PRV_CPM_TENR_VW T7392 /* F_PRV_CPM_TENURE */  On T3933.PERSON_ID = 
         T7392.PERSON_ID and T3933.BUSINESS_UNIT = T7392.BUSINESS_UNIT) left 
         outer join PS_SPB_PERS_EMAIL T8402 /* D_SERVICE_PROVD_EMAIL */  On 
         T3933.PERSON_ID = T8402.PERSON_ID,
         (
         (
         (
         PS_PRV_VNDR_SP_VW T3895 /* D_SUPPLIER */  left outer join 
         PS_PRV_VND_SPRO_VW T8005 /* F_PRV_VND_SPRO_VW */  On 
         T3895.BUSINESS_UNIT = T8005.BUSINESS_UNIT and T3895.VENDOR_ID = 
         T8005.VENDOR_ID) left outer join PS_PRV_VNDR_PHN_VW T8041 /* 
         F_PRV_VNDR_PHN_VW */  On T3895.BUSINESS_UNIT = T8041.BUSINESS_UNIT 
         and T3895.VENDOR_ID = T8041.VENDOR_ID) left outer join 
         PS_PRV_BU_SUPP_VW T8934 /* F_PRV_BU_SUPP_VW */  On 
         T3895.BUSINESS_UNIT = T8934.BUSINESS_UNIT and T3895.VENDOR_ID = 
         T8934.VENDOR_ID) left outer join PS_PRV_VND_ETNC_VW T8857 /* 
         F_PRV_VND_ETNC_VW */  On T8005.ETHNIC_CATEGORY = T8857.FIELDVALUE,
         (
         (
         PS_SPA_PLOG_DTL T6258 /* F_SPA_PLOG_DTL */  left outer join 
         PS_PRV_PLOGACT_VW T9112 /* D_PRV_PLOGACT_VW */  On 
         T6258.BUSINESS_UNIT = T9112.BUSINESS_UNIT and T6258.ACTIVITY_ID = 
         T9112.ACTIVITY_ID and T6258.WORK_ORDER_ID = T9112.WORK_ORDER_ID) left 
         outer join PS_PRV_PLOGHST_APR T9100 /* F_PRV_PLOGHST_APR */  On 
         T6258.BUSINESS_UNIT = T9100.BUSINESS_UNIT and T6258.PLOG_ID = 
         T9100.PLOG_ID and T6258.LINE_NBR = T9100.LINE_NBR) left outer join 
         PS_PRV_PLOGHST_SUB T9106 /* F_PRV_PLOGHST_SUB */  On 
         T6258.BUSINESS_UNIT = T9106.BUSINESS_UNIT and T6258.PLOG_ID = 
         T9106.PLOG_ID and T6258.LINE_NBR = T9106.LINE_NBR,
         PS_SPA_PLOG_HDR T6247 /* F_SPA_PLOG_HDR */ ,
         PS_PRV_PLOG_STS_VW T6907 /* D_XLAT_PLOG_STATUS */ 
         where  ( T3933.PERSON_ID = T5963.WO_CONID and T3933.BUSINESS_UNIT = 
         T5963.BUSINESS_UNIT and T3933.PERSON_ID = T5963.WO_CONID and 
         T3933.BUSINESS_UNIT = T5963.BUSINESS_UNIT and T3933.PERSON_ID = 
         T5963.WO_CONID and T3933.BUSINESS_UNIT = T5963.BUSINESS_UNIT and 
         T3895.BUSINESS_UNIT = T5963.BUSINESS_UNIT and T3895.VENDOR_ID = 
         T5963.VENDOR_ID and T3895.BUSINESS_UNIT = T5963.BUSINESS_UNIT and 
         T3895.VENDOR_ID = T5963.VENDOR_ID and T3895.BUSINESS_UNIT = 
         T5963.BUSINESS_UNIT and T3895.VENDOR_ID = T5963.VENDOR_ID and 
         T5963.BUSINESS_UNIT = T6258.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T6258.INVOICE_ID and T5963.INVOICE_LINE = T6258.INVOICE_LINE and 
         T5963.BUSINESS_UNIT = T6258.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T6258.INVOICE_ID and T5963.INVOICE_LINE = T6258.INVOICE_LINE and 
         T5963.BUSINESS_UNIT = T6258.BUSINESS_UNIT and T5963.INVOICE_ID = 
         T6258.INVOICE_ID and T5963.INVOICE_LINE = T6258.INVOICE_LINE )  and  
         ( T3895.BUSINESS_UNIT = T9021.BUSINESS_UNIT and T3933.BUSINESS_UNIT = 
         T9021.BUSINESS_UNIT and T5963.BUSINESS_UNIT = T9021.BUSINESS_UNIT and 
         T3880.BUSINESS_UNIT = T5963.BUSINESS_UNIT and T3880.BUSINESS_UNIT = 
         T9021.BUSINESS_UNIT and T6258.BUSINESS_UNIT = T9021.BUSINESS_UNIT and 
         T3933.PERSON_ID = T6247.PERSON_ID and T3933.BUSINESS_UNIT = 
         T6247.BUSINESS_UNIT and T6247.BUSINESS_UNIT = T6258.BUSINESS_UNIT and 
         T6247.PLOG_ID = T6258.PLOG_ID and T6247.PLOG_STATUS = 
         T6907.FIELDVALUE and T9021.OPRID = 'VKRISHNA' and 
         (T3880.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T3895.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T3933.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T5963.BUSINESS_UNIT in ('INI01', 'INI02', 'INI03')) and 
         (T6907.XLATLONGNAME in ('Adjusted', 'Approved', 'Denied', 'Pending', 
         'Submitted')) ) 
         order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12
      RATIONALE: SQL statement with SQL_ID "dd48205kfvw5v" was executed 3 
         times and had an average elapsed time of 158 seconds.
      RATIONALE: Average CPU used per execution was 137 seconds.
 
   RECOMMENDATION 5: SQL Tuning, 5.4% benefit (405 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "7k2ff5h45f6hy".
         RELEVANT OBJECT: SQL statement with SQL_ID 7k2ff5h45f6hy and 
         PLAN_HASH 1542827345
         select distinct T7396.TIME_SHEET_ID as c1,
         TRUNC(T7363.SUBMISSION_DATE) as c2,
         T8381.XLATLONGNAME as c3,
         T7363.TIME_HDR_STATUS as c4,
         TRUNC(T11231.DATETIME_STAMP) as c5,
         T11231.NAME_DISPLAY as c6,
         T9789.EMAILID as c7,
         T7435.DATE_UNDER_RPT as c8,
         T7435.SP_TIME_QTY as c9,
         T7435.TIME_AMOUNT as c10,
         T7396.SP_TIME_QTY as c11,
         T7396.TIME_AMOUNT as c12,
         TRUNC(T7363.PERIOD_START_DT) as c13,
         TRUNC(T7363.PERIOD_END_DT) as c14,
         T7424.SPA_START_TIME as c15,
         T7424.SPA_STOP_TIME as c16,
         T8160.BUSINESS_UNIT as c17
         from 
         (
         PS_SPA_TM_DTL_HRLY T7435 /* F_SPA_TM_DTL_HRLY */  left outer join (
         PS_SPA_TIM_DTL_DLY T7424 /* F_SPA_TIM_DTL_DLY */  left outer join (
         (
         (
         (
         (
         PS_PRV_WO_TMAMT_VW T8160 /* F_SERVICES_MGMT */  left outer join 
         PS_PRV_PROJECT_VW T5097 /* D_ACCT_PROJECT */  On T5097.BUSINESS_UNIT 
         = T8160.BUSINESS_UNIT and T5097.PROJECT_ID = T8160.PROJECT_ID) left 
         outer join PS_PRV_WORDERREC T10388 /* F_PRV_WORDERREC */  On 
         T8160.BUSINESS_UNIT = T10388.BUSINESS_UNIT and T8160.WORK_ORDER_ID = 
         T10388.WORK_ORDER_ID) left outer join PSOPRDEFN T9903 /* 
         F_PRV_EXPENSE_APPROVER_EMAIL */  On T8160.SP_EXP_APPROVER = 
         T9903.OPRID) left outer join PSOPRDEFN T9789 /* 
         F_PRV_TIMESHEET_APPROVER_EMAIL */  On T8160.TE_APPROVER = 
         T9789.OPRID) inner join PS_SEC_BU_OPR T10522 /* D_SEC_BU_OPR */  On 
         T8160.BUSINESS_UNIT = T10522.BUSINESS_UNIT) On T7424.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7424.WORK_ORDER_ID = T8160.WORK_ORDER_ID) On 
         T7435.BUSINESS_UNIT = T8160.BUSINESS_UNIT and T7435.WORK_ORDER_ID = 
         T8160.WORK_ORDER_ID) left outer join (
         (
         (
         PS_SPA_TIME_DTL T7396 /* F_SPA_TIME_DTL */  left outer join 
         PS_PRV_ACTVT_SP_VW T7684 /* D_ACTIVITY */  On T7396.BUSINESS_UNIT = 
         T7684.BUSINESS_UNIT and T7396.ACTIVITY_ID = T7684.ACTIVITY_ID) left 
         outer join PS_PRV_TIMHIST_APR T11231 /* F_PRV_TIMHIST_APR_SERVICES */ 
         On T7396.BUSINESS_UNIT = T11231.BUSINESS_UNIT and T7396.TIME_SHEET_ID 
         = T11231.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11231.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11231.LINE_NBR) left outer join 
         PS_PRV_TIMHIST_DEN T11238 /* F_PRV_TIMHIST_DEN_SERVICES */  On 
         T7396.BUSINESS_UNIT = T11238.BUSINESS_UNIT and T7396.TIME_SHEET_ID = 
         T11238.TIME_SHEET_ID and T7396.WORK_ORDER_ID = T11238.WORK_ORDER_ID 
         and T7396.LINE_NBR = T11238.LINE_NBR) On T7396.BUSINESS_UNIT = 
         T8160.BUSINESS_UNIT and T7396.WORK_ORDER_ID = T8160.WORK_ORDER_ID,
         PS_SPA_TIME_HDR T7363 /* F_SPA_TIME_HDR */ ,
         PS_PRV_TIME_STS_VW T8381 /* D_XLAT_TIME_HDR_STATUS */ 
         where  ( T7363.BUSINESS_UNIT = T7396.BUSINESS_UNIT and 
         T7363.TIME_SHEET_ID = T7396.TIME_SHEET_ID and T7363.TIME_HDR_STATUS = 
         T8381.FIELDVALUE and T7396.BUSINESS_UNIT = T10522.BUSINESS_UNIT and 
         T7396.BUSINESS_UNIT = 'MOUSA' and T7435.BUSINESS_UNIT = 
         T10522.BUSINESS_UNIT and T9789.OPRID = T11231.NAME_DISPLAY and 
         T10522.OPRID = 'KADELFS' and (T8381.XLATLONGNAME in ('Approved', 
         'Submitted')) and  TRUNC(T11231.DATETIME_STAMP) between 
         TO_DATE('2011-03-01' , 'YYYY-MM-DD') and TO_DATE('2011-03-24' , 
         'YYYY-MM-DD') ) 
         order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, 
         c15, c16
      RATIONALE: SQL statement with SQL_ID "7k2ff5h45f6hy" was executed 1 
         times and had an average elapsed time of 405 seconds.
      RATIONALE: Average CPU used per execution was 403 seconds.
 
FINDING 3: 7.1% impact (531 seconds)
------------------------------------
PL/SQL execution consumed significant database time.
 
   RECOMMENDATION 1: SQL Tuning, 4.8% benefit (361 seconds)
      ACTION: Investigate the SQL statement with SQL_ID "6mcpb06rctk0x" for 
         possible performance improvements.
         RELEVANT OBJECT: SQL statement with SQL_ID 6mcpb06rctk0x
         call dbms_space.auto_space_advisor_job_proc (  )
      RATIONALE: SQL statement with SQL_ID "6mcpb06rctk0x" was executed 1 
         times and had an average elapsed time of 361 seconds.
      RATIONALE: Average time spent in PL/SQL execution was 265 seconds.
 
   RECOMMENDATION 2: SQL Tuning, 3.7% benefit (277 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "8szmwam7fysa3".
         RELEVANT OBJECT: SQL statement with SQL_ID 8szmwam7fysa3 and 
         PLAN_HASH 1947143079
         insert into wri$_adv_objspace_trend_data select timepoint,  
         space_usage, space_alloc, quality from  
         table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL,  
         NULL, 'FALSE', :5, 'FALSE'))
      RATIONALE: SQL statement with SQL_ID "8szmwam7fysa3" was executed 33 
         times and had an average elapsed time of 8.2 seconds.
      RATIONALE: Average time spent in PL/SQL execution was 8 seconds.
 
FINDING 4: 6.6% impact (497 seconds)
------------------------------------
The SGA was inadequately sized, causing additional I/O or hard parses.
 
   RECOMMENDATION 1: DB Configuration, 6.6% benefit (497 seconds)
      ACTION: Increase the size of the SGA by setting the parameter 
         "sga_target" to 3584 M.
 
   ADDITIONAL INFORMATION:
      The value of parameter "sga_target" was "2048 M" during the analysis 
      period.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (23% impact [1752 seconds])
      SYMPTOM: Hard parsing of SQL statements was consuming significant 
               database time. (4.4% impact [330 seconds])
 
FINDING 5: 5.8% impact (434 seconds)
------------------------------------
Individual SQL statements responsible for significant user I/O wait were 
found.
 
   RECOMMENDATION 1: SQL Tuning, 3.7% benefit (277 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "8szmwam7fysa3".
         RELEVANT OBJECT: SQL statement with SQL_ID 8szmwam7fysa3 and 
         PLAN_HASH 1947143079
         insert into wri$_adv_objspace_trend_data select timepoint,  
         space_usage, space_alloc, quality from  
         table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL,  
         NULL, 'FALSE', :5, 'FALSE'))
      RATIONALE: SQL statement with SQL_ID "8szmwam7fysa3" was executed 33 
         times and had an average elapsed time of 8.2 seconds.
      RATIONALE: Average time spent in User I/O wait events per execution was 
         7.9 seconds.
 
   RECOMMENDATION 2: SQL Tuning, 2.4% benefit (180 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID 
         "89qyn4bbt03jq".
         RELEVANT OBJECT: SQL statement with SQL_ID 89qyn4bbt03jq and 
         PLAN_HASH 572015270
         SELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 
         0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT 
         TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, 
         SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, 
         (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP 
         BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND 
         F.TABLESPACE_NAME = U.TABLESPACE_NAME
      RATIONALE: SQL statement with SQL_ID "89qyn4bbt03jq" was executed 3 
         times and had an average elapsed time of 60 seconds.
      RATIONALE: Average time spent in User I/O wait events per execution was 
         57 seconds.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (23% impact [1752 seconds])
 
FINDING 6: 2.5% impact (188 seconds)
------------------------------------
The throughput of the I/O subsystem was significantly lower than expected.
 
   RECOMMENDATION 1: Host Configuration, 2.5% benefit (188 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 47 K per second for reads and 7.2 K per second for 
         writes. The average response time for single block reads was 8.6 
         milliseconds.
 
   RECOMMENDATION 2: Host Configuration, 1.3% benefit (96 seconds)
      ACTION: The performance of file +U04/orasp/users01.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
         "+U04/orasp/users01.dbf"
      RATIONALE: The average response time for single block reads for this 
         file was 19 milliseconds.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (23% impact [1752 seconds])
 
FINDING 7: 2.2% impact (169 seconds)
------------------------------------
The PGA was inadequately sized, causing additional I/O to temporary 
tablespaces to consume significant database time.
 
   RECOMMENDATION 1: DB Configuration, 0.16% benefit (12 seconds)
      ACTION: Increase the size of the PGA by setting the value of parameter 
         "pga_aggregate_target" to 192 M.
 
   ADDITIONAL INFORMATION:
      The value of parameter "pga_aggregate_target" was "24 M" during the 
      analysis period.
 
   SYMPTOMS THAT LED TO THE FINDING:
      SYMPTOM: Wait class "User I/O" was consuming significant database time. 
               (23% impact [1752 seconds])
 
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
          ADDITIONAL INFORMATION
          ----------------------
 
Wait class "Application" was not consuming significant database time.
Wait class "Cluster" was not consuming significant database time.
Wait class "Commit" was not consuming significant database time.
Wait class "Concurrency" was not consuming significant database time.
Wait class "Configuration" was not consuming significant database time.
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 42% 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.