【正文】 s (...Back to SQL Statistics Back to TopSQL ordered by Reads Total Disk Reads: 322,678 Captured SQL account for % of Total Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s)SQL IdSQL ModuleSQL Text66,286166,d8z0u8hgj8xdycuidmain@HPGICCI1 (TNS V1V3) insert into CUID select CUID_...50,646150,0yv9t4qb1zb2bcuidmain@HPGICCI1 (TNS V1V3) select CUID_CUST_NO , CUID_ID_...24,507124,569r5k05drsj7cumimain@HPGICCI1 (TNS V1V3) insert into CUMI select CUSV_...21,893121,ackxqhnktxnbccusmmain@HPGICCI1 (TNS V1V3) insert into CUSM select CUSM_...19,761119,a7nh7j8zmfrzwcumimain@HPGICCI1 (TNS V1V3) select CUSV_CUST_NO from CUMI...19,554119,38gak8u2qm11wSQL*Plus select count(*) from CUSVAA_T...6,34216,6z06gcfw39pkdSQL*Plus SELECT , TO_...4,38514,cp5duhcsj72q0cusmmain@HPGICCI1 (TNS V1V3) select CUSM_CUST_ACCT_NO from...635djs2w2f17nw2z DECLARE job BINARY_INTEGER := ...3511uk5m5qbzj1vtSQL*Plus BEGIN dbms_workload_repository...Back to SQL Statistics Back to TopSQL ordered by Executions Total Executions: 1,675,112 Captured SQL account for % of Total Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text172,983172,3295c4qu2zmj3guxload_fnsact@HPGICCI1 (TNS V1V3) select * from ICCIPRODCODE wh...172,983172,3297wwv1ybs9zguzload_fnsact@HPGICCI1 (TNS V1V3) update ICCIFNSACT set BORM_AD...172,337172,337gmn2w09rdxn14load_oldnewact@HPGICCI1 (TNS V1V3) insert into OLDNEWACT values ...172,329172,3291dm3bq36vu3g8load_fnsact@HPGICCI1 (TNS V1V3) insert into iccifnsact values...172,329172,32938apjgr0p55nsload_fnsact@HPGICCI1 (TNS V1V3) update ICCICCS set CCSMAXOVER...172,3296,2864vja2k2gdtyupload_fnsact@HPGICCI1 (TNS V1V3) insert into ICCICCS values (:...166,069166,0697gtztzv329wg0 select , from co...166,052166,0527v9dyf5r424yhicci_migact@HPGICCI1 (TNS V1V3) select NEWACTNO into :b0 from...166,051166,051chjmy0dxf9mbjicci_migact@HPGICCI1 (TNS V1V3) insert into ICCICCS values (:...51,74051,740bu8tnqr3xv25qload_fnsact@HPGICCI1 (TNS V1V3) select count(*) into :b0 fro...51,63351,63349ms69srnaxzjload_fnsact@HPGICCI1 (TNS V1V3) insert into ICCIRPYV values (...Back to SQL Statistics Back to TopSQL ordered by Parse Calls Total Parse Calls: 182,780 Captured SQL account for % of Total Parse CallsExecutions % Total ParsesSQL IdSQL ModuleSQL Text166,069166,0697gtztzv329wg0 select , from co...6,3046,3042ym6hhaq30r73 select type, blocks, extents,...2,4372,438bsa0wjtftg3uw select file from file$ where ...1,5681,5689qgtwh66xg6nz update seg$ set type=:4, bloc...1,5541,554aq4js2gkfjru8 update tsq$ set blocks=:3, max...444444104pd9mm3fh9p select blocks, maxblocks, gran...421421350f5yrnnmshs lock table $ in ex...421421g00cj285jmgsw update $ set inser...86863m8smr0v7v1m6 INSERT INTO $_adv_messa...8181f80h0xb1qvbsk SELECT $_adv_seq_msggro...Back to SQL Statistics Back to TopSQL ordered by Sharable MemoryNo data exists for this section of the report. Back to SQL Statistics Back to TopSQL ordered by Version CountNo data exists for this section of the report. Back to SQL Statistics Back to TopSQL ordered by Cluster Wait TimeCluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)ExecutionsSQL IdSQL ModuleSQL Text1d8z0u8hgj8xdycuidmain@HPGICCI1 (TNS V1V3) insert into CUID select CUID_...1569r5k05drsj7cumimain@HPGICCI1 (TNS V1V3) insert into CUMI select CUSV_...1ackxqhnktxnbccusmmain@HPGICCI1 (TNS V1V3) insert into CUSM select CUSM_...166,0697gtztzv329wg0 select , from co...172,3294vja2k2gdtyupload_fnsact@HPGICCI1 (TNS V1V3) insert into ICCICCS values (:...10yv9t4qb1zb2bcuidmain@HPGICCI1 (TNS V1V3) select CUID_CUST_NO , CUID_ID_...16z06gcfw39pkdSQL*Plus SELECT , TO_...1a7nh7j8zmfrzwcumimain@HPGICCI1 (TNS V1V3) select CUSV_CUST_NO from CUMI...444104pd9mm3fh9p select blocks, maxblocks, gran...138gak8u2qm11wSQL*Plus select count(*) from CUSVAA_T...1,554aq4js2gkfjru8 update tsq$ set blocks=:3, max...18704xtrk7uyhknh select obj, type, ctime, mti...172,337gmn2w09rdxn14load_oldnewact@HPGICCI1 (TNS V1V3) insert into OLDNEWACT values ...172,3291dm3bq36vu3g8load_fnsact@HPGICCI1 (TNS V1V3) insert into iccifnsact values...1cp5duhcsj72q0cusmmain@HPGICCI1 (TNS V1V3) select CUSM_CUST_ACCT_NO from...1,5689qgtwh66xg6nz update seg$ set type=:4, bloc...51,63349ms69srnaxzjload_fnsact@HPGICCI1 (TNS V1V3) insert into ICCIRPYV values (...166,051chjmy0dxf9mbjicci_migact@HPGICCI1 (TNS V1V3) insert into ICCICCS values (:...391gtsav2d5jhcusvaamain@HPGICCI1 (TNS V1V3) BEGIN BEGIN IF (...1215ngzsfstg8tmy select , , ...8078m9ryygp65v5cusvaamain@HPGICCI1 (TNS V1V3) SELECT /*+ ALL_ROWS */ COUNT(*...17bwt0pmxhv7qk7 delete from con$ where owner=...32753saa2zkr6wc3 select intcol, nvl(pos, 0), ...1d92h3rjp0y217 begin ( :...837ng34ruy5awxq select , , ,...770hhmdwwgxbw0r select obj, type, flags, ...45a2any035u1qz1 select owner, name from con$...11uk5m5qbzj1vtSQL*Plus BEGIN dbms_workload_repository...