Oracle - AWR - 教你如何看 - 图文(6)

? ? ?

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 …… 此处隐藏：2491字，全部文档内容请下载后查看。喜欢就下载吧 ……