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

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