【正文】 Captured SQL account for % of Total Parse CallsExecutions % Total ParsesSQL IdSQL ModuleSQL Text166,069166,0697gtztzv329wg0 select , from co...1,427,648172,337gmn2w09rdxn14load_oldnewactHPGICCI1 (TNS V1V3) insert into OLDNEWACT values ...1,278,667172,3291dm3bq36vu3g8load_fnsactHPGICCI1 (TNS V1V3) insert into iccifnsact values...1,216,36711,216,ackxqhnktxnbccusmmainHPGICCI1 (TNS V1V3) insert into CUSM select CUSM_...1,107,30511,107,569r5k05drsj7cumimainHPGICCI1 (TNS V1V3) insert into CUMI select CUSV_...898,868172,9837wwv1ybs9zguzload_fnsactHPGICCI1 (TNS V1V3) update ICCIFNSACT set BORM_AD...711,450166,051chjmy0dxf9mbjicci_migactHPGICCI1 (TNS V1V3) insert into ICCICCS values (:...692,996172,32938apjgr0p55nsload_fnsactHPGICCI1 (TNS V1V3) update ICCICCS set CCSMAXOVER...666,748166,0527v9dyf5r424yhicci_migactHPGICCI1 (TNS V1V3) select NEWACTNO into :b0 from...345,357172,9835c4qu2zmj3guxload_fnsactHPGICCI1 (TNS V1V3) select * from ICCIPRODCODE wh...231,75651,63349ms69srnaxzjload_fnsactHPGICCI1 (TNS V1V3) insert into ICCIRPYV values (...Back to SQL Statistics Back to TopSQL ordered by Reads Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. 在STATSPACK報告中，沒有完整的SQL語句，可使用報告中的Hash Value通過下面語句從數(shù)據(jù)庫中查到：select sql_textfrom stats$sqltextwhere hash_value = amp。 SQL ordered by Executions ordered by DB Time Service NameDB Time (s)DB CPU (s)Physical ReadsLogical ReadsICCI315,84916,550,972SYS$USERS6,53958,929ICCIXDB00SYS$BACKGROUND28238,990Back to Wait Events Statistics Back to TopService Wait Class StatsLog File Sync事件，當(dāng)用戶SESSION執(zhí)行事務(wù)操作（COMMIT或ROLLBACK等）后，會通知 LGWR進程將所需要的所有REDO信息從LOG BUFFER寫到LOG文件，在用戶SESSION等待LGWR返回安全寫入磁盤的通知時發(fā)生此等待。通過在批量應(yīng)用中，DB file sequential read是很影響性能的事件，總是應(yīng)當(dāng)設(shè)法避免。 s second background cpu time Background Wait Events Library Cache Statistics IO Stats 在這里，log file parallel write是相對比較多的等待，占用了7%的CPU時間。Top 5 Timed Events EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait ClassCPU timeExecute to Parse：是語句執(zhí)行與分析的比例，如果要SQL重用率高，則這個比例會很高。如果太低（可參考90%閥值），考慮增加LOG BUFFER。其中Buffer Hit Ratio 也稱Cache Hit Ratio，Library Hit ratio也稱Library Cache Hit ratio。　　對sql語句進行解析(prase)　　利用內(nèi)部算法對sql進行解析，生成解析樹(parse tree)及執(zhí)行計劃(execution plan)。Load ProfilePer SecondPer TransactionRedo size:918,775,Logical reads:3,2,Block changes:1,1,Physical reads:Physical writes:User calls:Parses:Hard parses:Sorts:Logons:Executes:Transactions:如果快照周期不在這一段時間內(nèi)，或者快照周期跨度太長而包含了大量的數(shù)據(jù)庫空閑時間，所得出的分析結(jié)果是沒有意義的。DB Time: (mins)這也說明選擇分析時間段很關(guān)鍵，要選擇能夠代表性能問題的時間段。% Blocks changed per Read:Recursive Call %:Rollback per transaction %:Rows per Sort:顯示數(shù)據(jù)庫負(fù)載概況，將之與基線數(shù)據(jù)比較才具有更多的意義，如果每秒或每事務(wù)的負(fù)載變化不大，說明應(yīng)用運行比較穩(wěn)定。　　執(zhí)行sql，返回結(jié)果(execute and return)　　其中，軟、硬解析就發(fā)生在第三個過程里。同Load Profile一節(jié)相同，這一節(jié)也沒有所謂“正確”的值，而只能根據(jù)應(yīng)用的特點判斷是否合適。library hit表示Oracle從Library Cache中檢索到一個解析過的SQL或PL/SQL語句的比率，當(dāng)應(yīng)用程序調(diào)用SQL或存儲過程時，Oracle檢查Library Cache確定是否存在解析過的版本，如果存在，Oracle立即執(zhí)行語句；如果不存在，Oracle解析此語句，并在Library Cache中為它分配共享SQL區(qū)。該值越高表示一次解析后被重復(fù)執(zhí)行的次數(shù)越多。515通常，在沒有問題的數(shù)據(jù)庫中，CPU time總是列在第一個。 Buffer Pool Statistics Memory Statistics Operating System Statistics 此節(jié)顯示了各種類型的數(shù)據(jù)庫處理任務(wù)所占用的CPU時間。 cs centisecond 100th of a second Log File Parallel Write事件是在等待LGWR進程將REDO記錄從LOG 緩沖區(qū)寫到聯(lián)機日志文件時發(fā)生的。減少此等待的方法寫Log File Parallel Write事件的處理。 Wait Class info for services in the Service Statistics section. SQL ordered by Parse Calls hash_valueorder by piece。 % 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 Total Disk Reads: 322,678 select , from co...6,3046,3042ym6hhaq30r73 INSERT INTO $_adv_messa...8181f80h0xb1qvbsk delete from con$ where owner=...32753saa2zkr6wc3 begin ( :...837ng34ruy5awxq 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 select file from file$ where ...1,5681,5689qgtwh66xg6nz DECLARE job BINARY_INTEGER := ...3511uk5m5qbzj1vtSQL*Plus BEGIN dbms_workload_repository...Back to SQL Statistics Back to TopSQL ordered by Executions DECLARE job BINARY_INTEGER := ...88172,32938apjgr0p55nsload_fnsactHPGICCI1 (TNS V1V3) update ICCICCS set CCSMAXOVER...81051crajpb7j5tyz Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. SQL ordered by Version Count 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