【正文】 select obj, type, flags, ...45a2any035u1qz1 begin ( :...837ng34ruy5awxq delete from con$ where owner=...32753saa2zkr6wc3 update seg$ set type=:4, bloc...51,63349ms69srnaxzjload_fnsactHPGICCI1 (TNS V1V3) insert into ICCIRPYV values (...166,051chjmy0dxf9mbjicci_migactHPGICCI1 (TNS V1V3) insert into ICCICCS values (:...391gtsav2d5jhcusvaamainHPGICCI1 (TNS V1V3) BEGIN BEGIN IF (...1215ngzsfstg8tmy update tsq$ set blocks=:3, max...18704xtrk7uyhknh select , from co...172,3294vja2k2gdtyupload_fnsactHPGICCI1 (TNS V1V3) insert into ICCICCS values (:...10yv9t4qb1zb2bcuidmainHPGICCI1 (TNS V1V3) select CUID_CUST_NO , CUID_ID_...16z06gcfw39pkdSQL*Plus SELECT , TO_...1a7nh7j8zmfrzwcumimainHPGICCI1 (TNS V1V3) select CUSV_CUST_NO from CUMI...444104pd9mm3fh9p INSERT INTO $_adv_messa...8181f80h0xb1qvbsk lock table $ in ex...421421g00cj285jmgsw update tsq$ set blocks=:3, max...444444104pd9mm3fh9p select file from file$ where ...1,5681,5689qgtwh66xg6nz select , from co...6,3046,3042ym6hhaq30r73 Total Parse Calls: 182,780 Captured SQL account for % of Total Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text172,983172,3295c4qu2zmj3guxload_fnsactHPGICCI1 (TNS V1V3) select * from ICCIPRODCODE wh...172,983172,3297wwv1ybs9zguzload_fnsactHPGICCI1 (TNS V1V3) update ICCIFNSACT set BORM_AD...172,337172,337gmn2w09rdxn14load_oldnewactHPGICCI1 (TNS V1V3) insert into OLDNEWACT values ...172,329172,3291dm3bq36vu3g8load_fnsactHPGICCI1 (TNS V1V3) insert into iccifnsact values...172,329172,32938apjgr0p55nsload_fnsactHPGICCI1 (TNS V1V3) update ICCICCS set CCSMAXOVER...172,3296,2864vja2k2gdtyupload_fnsactHPGICCI1 (TNS V1V3) insert into ICCICCS values (:...166,069166,0697gtztzv329wg0 DECLARE job BINARY_INTEGER := ...3511uk5m5qbzj1vtSQL*Plus BEGIN dbms_workload_repository...Back to SQL Statistics Back to TopSQL ordered by Executions Total Disk Reads: 322,678 Captured SQL account for % of Total Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s)SQL IdSQL ModuleSQL Text3,305,363172,3294vja2k2gdtyupload_fnsactHPGICCI1 (TNS V1V3) insert into ICCICCS values (:...2,064,41412,064,d8z0u8hgj8xdycuidmainHPGICCI1 (TNS V1V3) insert into CUID select CUID_...1,826,869166,0697gtztzv329wg0 Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. DECLARE job BINARY_INTEGER := ...88172,32938apjgr0p55nsload_fnsactHPGICCI1 (TNS V1V3) update ICCICCS set CCSMAXOVER...81051crajpb7j5tyz % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB TimeSQL IdSQL ModuleSQL Text7576172,3294vja2k2gdtyupload_fnsactHPGICCI1 (TNS V1V3) insert into ICCICCS values (:...57931d8z0u8hgj8xdycuidmainHPGICCI1 (TNS V1V3) insert into CUID select CUID_...42511ackxqhnktxnbccusmmainHPGICCI1 (TNS V1V3) insert into CUSM select CUSM_...42581569r5k05drsj7cumimainHPGICCI1 (TNS V1V3) insert into CUMI select CUSV_...3638166,0697gtztzv329wg0 INSERT INTO STATS$SGA_TARGET_A...88172,32938apjgr0p55nsload_fnsactHPGICCI1 (TNS V1V3) update ICCICCS set CCSMAXOVER...88172,9835c4qu2zmj3guxload_fnsactHPGICCI1 (TNS V1V3) select * from ICCIPRODCODE wh...Back to SQL Statistics Back to TopSQL ordered by CPU Time select , from co...35316z06gcfw39pkdSQL*Plus SELECT , TO_...2323172,3291dm3bq36vu3g8load_fnsactHPGICCI1 (TNS V1V3) insert into iccifnsact values...15115djs2w2f17nw2z Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. hash_valueorder by piece。在一個(gè)I/O等待是最嚴(yán)重事件的系統(tǒng)中，調(diào)優(yōu)的目標(biāo)應(yīng)該是physical IOs最多的SQL語句。 Complete List of SQL Text 本節(jié)按各種資源分別列出對(duì)資源消耗最嚴(yán)重的SQL語句，并顯示它們所占統(tǒng)計(jì)期內(nèi)全部資源的比例，這給出我們調(diào)優(yōu)指南。 SQL ordered by Version Count SQL ordered by Parse Calls SQL ordered by Reads SQL ordered by CPU Time Time Waited (Wt Time) in centisecond (100th of a second) Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt TimeICCI59826864046213380015640596552SYS$USERS65673238231110073233SYS$BACKGROUND4431153301680000Back to Wait Events Statistics Back to TopSQL Statistics Wait Class info for services in the Service Statistics section. AVG_BUSY_TIME： BUSY_TIME / NUM_CPUSAVG_IDLE_TIME： IDLE_TIME / NUM_CPUSAVG_IOWAIT_TIME： IOWAIT_TIME / NUM_CPUSAVG_SYS_TIME： SYS_TIME / NUM_CPUSAVG_USER_TIME： USER_TIME / NUM_CPUSar oBUSY_TIME： time equiv of %usr+%sys in sar outputIDLE_TIME： time equiv of %idle in sarIOWAIT_TIME： time equiv of %wio in sarSYS_TIME： time equiv of %sys in sarUSER_TIME： time equiv of %usr in sarLOAD： 未知OS_CPU_WAIT_TIME： supposedly time waiting on run queuesRSRC_MGR_CPU_WAIT_TIME： time waited coz of resource managerPHYSICAL_MEMORY_BYTES： total memory in use supposedlyNUM_CPUS： number of CPUs reported by OSNUM_CPU_CORES： number of CPU sockets on motherboard總的elapsed time也可以用以公式計(jì)算：BUSY_TIME + IDLE_TIME + IOWAIT TIME或：SYS_TIME + USER_TIME + IDLE_TIME + IOWAIT_TIME （因?yàn)锽USY_TIME = SYS_TIME+USER_TIME）Back to Wait Events Statistics