"query and current" values in TKPROF
When I run the same query twice and generate the tkprof, I see some interesting results. Second time it runs, it is extremely slow and I am trying to determine all possible causes for the slowness. One thing that I have discovered is the avg wait time for db file sequential reads and direct path writes are much higher when the query runs slower. Now, that is a no brainer. It could be a busy IO subsystem. That is not my real issue.
I also notice that the Query+current count during the slow query, is 10 times higher than when it is exhibiting normal performance. Why is that?. It is the exact same query resulting in same number of rows. Could undo blocks be causing this multi-fold increase?
0