? ? ?
Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 16,648,792
Captured SQL account for 97.9% of Total
CPU Time (s) Buffer Gets 3,305,363 2,064,414 1,826,869 1,427,648 1,278,667 1,216,367 1,107,305 898,868 Executions 172,329 Gets per Exec 19.18 %Total Elapsed Time (s) SQL Id SQL Module SQL Text 19.85 74.57 76.41 4vja2k2gdtyuload_fnsact@HPGICCIp 1 (TNS V1-V3) 93.50 d8z0u8hgj8xdcuidmain@HPGICCI1 y (TNS V1-V3) 37.60 7gtztzv329wg 0 13.29 gmn2w09rdxn14 insert into ICCICCS values (:... insert into CUID select CUID_... select c.name, u.name from co... 1 2,064,414.00 166,069 11.00 12.40 57.31 10.97 35.84 172,337 8.28 8.58 12.97 load_oldnewact@HPGIinsert into CCI1 (TNS V1-V3) OLDNEWACT values ... insert into iccifnsact values... 172,329 7.42 7.68 22.85 22.94 1dm3bq36vu3load_fnsact@HPGICCIg8 1 (TNS V1-V3) 50.93 ackxqhnktxnbc 1 1,216,367.00 1 1,107,305.00 172,983 5.20 7.31 42.43 cusmmain@HPGICCI1 insert into (TNS V1-V3) CUSM select CUSM_... insert into CUMI select CUSV_... update ICCIFNSACT set BORM_AD... 6.65 42.01 58.04 569r5k05drsj7 cumimain@HPGICCI1 (TNS V1-V3) 14.34 7wwv1ybs9zgload_fnsact@HPGICCIuz 1 (TNS V1-V3) 5.40 14.28 711,450 166,051 4.28 4.27 12.52 12.55 chjmy0dxf9micci_migact@HPGICCI1 insert into bj (TNS V1-V3) ICCICCS values (:... 8.31 38apjgr0p55nload_fnsact@HPGICCIs 1 (TNS V1-V3) update ICCICCS set CCSMAXOVER... 692,996 172,329 4.02 4.16 8.31 666,748 166,052 4.02 4.00 6.36 6.36 7v9dyf5r424yicci_migact@HPGICCI1 select h (TNS V1-V3) NEWACTNO into :b0 from... 7.71 5c4qu2zmj3gload_fnsact@HPGICCIux 1 (TNS V1-V3) 5.83 49ms69srnaxload_fnsact@HPGICCIzj 1 (TNS V1-V3) select * from ICCIPRODCODE wh... insert into ICCIRPYV values (... 345,357 172,983 2.00 2.07 7.70 231,756 51,633 4.49 1.39 5.75 Back to SQL Statistics Back to Top
SQL ordered by Reads
? ?
Physical Reads Total Disk Reads: 322,678
Captured SQL account for 66.1% of Total
Reads %Totper al Exec CPU TimElapsed Time Executions SQL Id SQL Module SQL Text e (s) 66,286 50,646 1 66,286.00 1 50,646.00 1 24,507.00 1 21,893.00 1 19,761.00 1 19,554.00 1 6,342.00 1 4,385.00 5 12.60 20.54 57.31 15.70 3.54 (s) 93.50 d8z0u8hgj8xdcuidmain@HPGICinsert into CUID select y CI1 (TNS V1-V3) CUID_... 9.70 0yv9t4qb1zb2cuidmain@HPGICselect b CI1 (TNS V1-V3) CUID_CUST_NO , CUID_ID_... 58.04 569r5k05drsj7 50.93 ackxqhnktxnbc cumimain@HPGICinsert into CUMI select CI1 (TNS V1-V3) CUSV_... cusmmain@HPGIinsert into CUSM select CCI1 (TNS V1-V3) CUSM_... 24,507 21,893 19,761 7.59 42.01 6.78 42.43 6.12 2.14 6.04 a7nh7j8zmfrzcumimain@HPGICselect w CI1 (TNS V1-V3) CUSV_CUST_NO from CUMI... 3.83 38gak8u2qm1SQL*Plus 1w 35.00 6z06gcfw39pkd 2.43 cp5duhcsj72q0 14.91 djs2w2f17nw2z SQL*Plus select count(*) from CUSVAA_T... SELECT F.TABLESPACE_NAME, TO_... 19,554 6,342 6.06 1.27 1.97 3.13 4,385 1.36 1.59 cusmmain@HPGIselect CCI1 (TNS V1-V3) CUSM_CUST_ACCT_NO from... DECLARE job BINARY_INTEGER := ... BEGIN dbms_workload_repository... 63 0.02 11.17 0.01 0.08 35 1 35.00 0.67 1uk5m5qbzj1SQL*Plus vt Back to SQL Statistics Back to Top
SQL ordered by Executions
? ?
Total Executions: 1,675,112
Captured SQL account for 99.8% of Total
CPU per Exec (s) 0.00 Elap per Exec (s) Executions 172,983 Rows Processed 172,329 Rows per Exec 1.00 SQL Id SQL Module SQL Text select * from ICCIPRODCODE wh... update ICCIFNSACT set BORM_AD... 0.00 5c4qu2zmj3gux load_fnsact@HPGICCI1 (TNS V1-V3) 0.00 7wwv1ybs9zguz load_fnsact@HPGICCI1 (TNS V1-V3) 0.00 gmn2w09rdxn14 0.00 1dm3bq36vu3g8 0.00 38apjgr0p55ns 172,983 172,329 1.00 0.00 172,337 172,337 1.00 0.00 load_oldnewact@HPGICCIinsert into 1 (TNS V1-V3) OLDNEWACT values ... load_fnsact@HPGICCI1 (TNS V1-V3) load_fnsact@HPGICCI1 (TNS V1-V3) insert into iccifnsact values... update ICCICCS set CCSMAXOVER... insert into ICCICCS values (:... select c.name, u.name from co... 172,329 172,329 1.00 0.00 172,329 172,329 1.00 0.00 172,329 6,286 0.04 0.00 0.00 4vja2k2gdtyup load_fnsact@HPGICCI1 (TNS V1-V3) 166,069 166,069 1.00 0.00 0.00 7gtztzv329wg0 166,052 166,052 1.00 0.00 0.00 7v9dyf5r424yh icci_migact@HPGICCI1 (TNS V1-V3) select NEWACTNO into :b0 from... insert into ICCICCS values (:... select count(*) into :b0 fro... insert into ICCIRPYV values (... 166,051 166,051 1.00 0.00 0.00 chjmy0dxf9mbj icci_migact@HPGICCI1 (TNS V1-V3) 0.00 bu8tnqr3xv25q load_fnsact@HPGICCI1 (TNS V1-V3) 0.00 49ms69srnaxzj load_fnsact@HPGICCI1 (TNS V1-V3) 51,740 51,633 51,740 51,633 1.00 1.00 0.00 0.00 Back to SQL Statistics Back to Top
SQL ordered by Parse Calls
? ?
Parse Calls 166,069 6,304 2,437 1,568 1,554 444 421 421 86 81 Total Parse Calls: 182,780
Captured SQL account for 99.0% of Total
% Total Parses SQL Module Executions 166,069 6,304 2,438 1,568 1,554 444 421 421 86 81 SQL Id SQL Text select c.name, u.name from co... select type#, blocks, extents,... select file# from file$ where ... update seg$ set type#=:4, bloc... update tsq$ set blocks=:3, max... select blocks, maxblocks, gran... lock table sys.mon_mods$ in ex... update sys.mon_mods$ set inser... INSERT INTO sys.wri$_adv_messa... SELECT sys.wri$_adv_seq_msggro... 90.86 7gtztzv329wg0 1.33 bsa0wjtftg3uw 0.85 aq4js2gkfjru8 0.23 350f5yrnnmshs 0.23 g00cj285jmgsw 3.45 2ym6hhaq30r73 0.86 9qgtwh66xg6nz 0.24 104pd9mm3fh9p 0.05 3m8smr0v7v1m6 0.04 f80h0xb1qvbsk Back to SQL Statistics Back to Top
SQL ordered by Sharable Memory
No data exists for this section of the report.
Back to SQL Statistics Back to Top
SQL ordered by Version Count
No data exists for this section of the report.
Back to SQL Statistics Back to Top
SQL ordered by Cluster Wait Time
Cluster CWT % of Elapsed CPU Time(Executions SQL Id SQL Module SQL Text Wait Time (s) 10.96 4.21 3.62 2.39 2.38 1.64 Elapsd Time 11.72 7.25 7.12 6.35 3.12 16.91 Time(s) 93.50 58.04 50.93 37.60 76.41 9.70 s) 57.31 42.01 42.43 35.84 74.57 3.54 1 d8z0u8hgj8xdy cuidmain@HPGICCI1 (TNS V1-V3) 1 569r5k05drsj7 cumimain@HPGICCI1 (TNS V1-V3) 1 ackxqhnktxnbc insert into CUID select CUID_... insert into CUMI select CUSV_... cusmmain@HPGICCI1 insert into CUSM select (TNS V1-V3) CUSM_... select c.name, u.name from co... 166,069 7gtztzv329wg0 172,329 4vja2k2gdtyup load_fnsact@HPGICCI1 insert into ICCICCS (TNS V1-V3) values (:... 1 0yv9t4qb1zb2b cuidmain@HPGICCI1 (TNS V1-V3) 1 6z06gcfw39pkd SQL*Plus select CUID_CUST_NO , CUID_ID_... SELECT F.TABLESPACE_NAME, TO_... select CUSV_CUST_NO from CUMI... select blocks, maxblocks, gran... select count(*) from CUSVAA_T... update tsq$ set blocks=:3, max... select obj#, type#, ctime, mti... insert into OLDNEWACT values ... 1.06 3.02 35.00 3.13 0.83 13.76 6.04 2.14 1 a7nh7j8zmfrzw cumimain@HPGICCI1 (TNS V1-V3) 444 104pd9mm3fh9p 0.66 0.50 0.50 0.33 0.33 0.29 0.25 87.90 13.01 51.75 91.11 2.47 1.26 10.14 0.75 3.83 0.96 0.36 13.29 22.94 2.43 0.42 1.27 0.79 0.33 12.97 22.85 1.59 1 38gak8u2qm11SQL*Plus w 1,554 aq4js2gkfjru8 187 04xtrk7uyhknh 172,337 gmn2w09rdxn14 172,329 1dm3bq36vu3g8 1 cp5duhcsj72q0 load_oldnewact@HPGICCI1 (TNS V1-V3) load_fnsact@HPGICCI1 insert into iccifnsact (TNS V1-V3) values... cusmmain@HPGICCI1 select (TNS V1-V3) CUSM_CUST_ACCT_NO from... update seg$ set type#=:4, bloc... 0.21 0.20 0.17 0.16 0.14 0.11 27.92 3.49 1.39 57.64 74.58 64.72 0.74 5.83 12.55 0.28 0.19 0.18 0.74 5.75 12.52 0.24 0.14 0.15 1,568 9qgtwh66xg6n z 51,633 49ms69srnaxzj load_fnsact@HPGICCI1 insert into ICCIRPYV (TNS V1-V3) values (... 166,051 chjmy0dxf9mbicci_migact@HPGICCI1 insert into ICCICCS j (TNS V1-V3) values (:... 39 cn1gtsav2d5jh cusvaamain@HPGICCIBEGIN BEGIN IF 1 (TNS V1-V3) (xdb.DBMS... 121 5ngzsfstg8tmy select o.owner#, o.name, o.nam... 80 78m9ryygp65vcusvaamain@HPGICCISELECT /*+ 5 1 (TNS V1-V3) ALL_ROWS */ COUNT(*... 17 bwt0pmxhv7qk7 327 53saa2zkr6wc3 delete from con$ where owner#=... select intcol#, nvl(pos#, 0), ... begin prvt_hdm.auto_execute( :... select i.obj#, i.ts#, i.file#,... select obj#, type#, flags, ... 0.11 0.11 0.08 94.54 80.26 19.20 0.12 0.14 0.42 0.01 0.14 0.24 1 d92h3rjp0y217 0.07 0.06 54.97 5.22 0.13 1.13 0.13 0.72 83 7ng34ruy5awx q 77 0hhmdwwgxbw0r 0.06 0.06 86.50 8.19 0.06 0.67 0.06 0.08 45 a2any035u1qz 1 1 1uk5m5qbzj1vt SQL*Plus select owner#, name from con$... BEGIN dbms_workload_repository... select pos#, intcol#, col#, sp... select file#, block# from seg... select type#, blocks, extents,... delete from RecycleBin$ ... select t.ts#, t.file#, t.block... update obj$ set obj#=:6, type#... INSERT INTO sys.wri$_adv_messa... delete from RecycleBin$ ... select con# from con$ where ow... select name, intcol#, segcol#,... DECLARE job BINARY_INTEGER := ... 0.04 0.04 0.04 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 75.69 48.05 8.84 28.15 66.23 67.03 66.73 26.94 76.76 51.91 0.15 2.12 53.82 0.10 8.29 0.06 0.09 0.40 0.12 0.05 0.05 0.04 0.09 0.03 0.05 14.91 1.00 0.03 14.34 0.16 0.06 0.07 0.40 0.12 0.05 0.05 0.04 0.09 0.03 0.05 11.17 0.99 0.03 14.28 0.13 87 6769wyy3yf66f 7 0pvtkmrrq8usg 6,304 2ym6hhaq30r7 3 49 b52m6vduutr8j 85 1gu8t96d0bdm u 38 btzq46kta67dz DBMS_SCHEDULER 86 3m8smr0v7v1m6 38 0k8h617b8guh f 51 9vtm7gy4fr2ny 84 83taa7kaw59c1 5 djs2w2f17nw2z 8,784 501v412s13r4m 39 bdv0rkkssq2jm 172,983 7wwv1ybs9zguz 421 g00cj285jmgsw load_fnsact@HPGICCI1 update ICCIFNSACT set (TNS V1-V3) BORM_FA... cusvaamain@HPGICCISELECT count(*) FROM 1 (TNS V1-V3) user_poli... load_fnsact@HPGICCI1 update ICCIFNSACT set (TNS V1-V3) BORM_AD... update sys.mon_mods$ set inser... insert into wrh$_latch (snap... insert into ICCICURMMAST valu... 0.01 0.01 0.01 1.65 22.33 0.08 0.56 0.04 7.71 0.54 0.02 7.70 2 84qubbrsr0kfn 26 44au3v5mzpc1load_curmmast@HPGIc CCI1 (TNS V1-V3) 172,983 5c4qu2zmj3guload_fnsact@HPGICCI1 select * from x (TNS V1-V3) ICCIPRODCODE wh... Back to SQL Statistics
Back to Top
Complete List of SQL Text
SQL Id SQL Text 04xtrk7select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where uyhknh owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null 0hhmdselect obj#, type#, flags, related, bo, purgeobj, con# from RecycleBin$ where ts#=:1 and wwgxbto_number(bitand(flags, 16)) = 16 order by dropscn w0r 0k8h61delete from RecycleBin$ where purgeobj=:1 7b8guhf 0pvtkmselect file#, block# from seg$ where type# = 3 and ts# = :1 rrq8us