[10.2.0.4 on W2K3] Analyzing AWR report
Hi,
Here's a part of my AWR report.
1) DB CPU is the most signicant time, how could I get more informations about that in my report ?
I thought I could use the part "Timed Statistics" but :
sum of statistics below DB CPU and until DB Time > DB CPU so what is included in DB CPU ?
2) Execute To Parse ratio is négative, that means I've got more parse than execution.
how could I get more informations about that in my report ?
Remark : no sql order list in my report shows problem of elapsed time or cpu time.
Rgds,
Frederic
1) DB CPU is the most signicant time, how could I get more informations about that in my report ?
I thought I could use the part "Timed Statistics" but :
sum of statistics below DB CPU and until DB Time > DB CPU so what is included in DB CPU ?
2) Execute To Parse ratio is négative, that means I've got more parse than execution.
how could I get more informations about that in my report ?
Remark : no sql order list in my report shows problem of elapsed time or cpu time.
Rgds,
Frederic
|
| Snap Id |
|---|
0