问题诊断方法.pptxVIP

EBS问题诊断常用方法 --Oracle SSC --Andrew Du;Topics;How To Get Level 12 Trace?为什么需要Trace?;How To Get Level 12 Trace?Gathering 10046 trace;How To Get Level 12 Trace?在EBS中启用10046 trace;How To Get Level 12 Trace?Session Tracing ;How To Get Level 12 Trace?Trace other Session;How To Get Level 12 Trace?;How To Get Level 12 Trace? What to look for in the trace?;How To Get Level 12 Trace? How to read a Raw Trace (note 39817.1);How To Get Level 12 Trace? How to read a raw trace (cont.);How To Get Level 12 Trace? Raw Trace+Understanding=Root Cause;Trace file analyze tool;sort=option Set of zero or more of the following sort options: prscnt number of times parse was called prscpu cpu time parsing prsela elapsed time parsing prsdsk number of disk reads during parse prsqry number of buffers for consistent read during parse prscu number of buffers for current read during parse prsmis number of misses in library cache during parse execnt number of execute was called execpu cpu time spent executing exeela elapsed time executing exedsk number of disk reads during execute exeqry number of buffers for consistent read during execute execu number of buffers for current read during execute exerow number of rows processed during execute exemis number of library cache misses during execute ;fchcnt number of times fetch was called fchcpu cpu time spent fetching fchela elapsed time fetching fchdsk number of disk reads during fetch fchqry number of buffers for consistent read during fetch fchcu number of buffers for current read during fetch fchrow number of rows fetched ;Trace file analyze(TKProf Interpretation );Note 29012.1 TKPROF Usage - Quick Reference.mht TKProf Interpretation (9i and above) [ID 760786.1] Parse - statistics from parsing the cursor. This includes information for plan generation etc. Execute - statistics for the execution phase of a cursor Fetch - statistics for actually fetching the rows count - number of times each indi