Hi,
We're having
slow response on some batch jobs in our production system. A straight SQL
trace shows intermittant slow response times on selects against a variety of
tables. What is odd is:
- the statistics are current for the tables, frequently the results of a compute.
- The same cursor with different bind variables will randomly vary from 200 microseconds to 3.6 seconds, randomly.
- This occurs on multiple tables in multiple tablespaces.
What is this
normally indicative of?
The other thing I
did was run a 10046 level 8 trace for about 20 seconds. I saw 22 log file
sync's in that period in the trace file.
Any thoughts
welcome.
Russ