Re: slow queries and high % of wait I/O
Posted by:
Rick James
Date: January 20, 2009 08:41PM
"the number of rows returned is usually 25. However, because of a bug in our application, at times we have around 200 or 300 and in some instances, it is even around 2000." ---
If the average is over about 100, then then this might account for all the elapsed time, namely doing disk seeks.
So, probably fixing that 'bug' will solve the whole issue. The disk will run warm, but acceptably.
I have focused on tallying the disk hits; you have perhaps accounted for enough to explain the delays. I can't think of anything else to look for.
Subject
Views
Written By
Posted
9613
January 19, 2009 01:58PM
3541
January 19, 2009 04:22PM
3114
January 19, 2009 05:36PM
2864
January 19, 2009 09:00PM
2763
January 19, 2009 11:37PM
2674
January 20, 2009 12:50PM
2469
January 21, 2009 12:29AM
2598
January 21, 2009 01:22AM
2418
January 21, 2009 05:23PM
2488
January 20, 2009 12:46AM
2543
January 20, 2009 01:28AM
2366
January 20, 2009 01:27PM
Re: slow queries and high % of wait I/O
2480
January 20, 2009 08:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.