Basically i was going through the statspack result where i came across
the
low execute to parse issue(1.48%) which was way too low against target
of 100%
So i submitted it to the group which in turn indicated about bind
variables. Again i went back to the stats report to chk the gets and
read related sql statements and found the bind variables of the sql
statements to be in place. That means it is not from bind variables. I
am intrigued as to what is causing these values to be so low.
Now does the wait event which i attached y'day show any discrepancy
like high scattered read or sequential read etc.Pls let me know if u
find anything unusual.
Also is there any material that can shed light on how to interpret
statspack results.
Thks for your help.
rgds
Received on Sun Sep 11 2005 - 04:26:41 CDT
