Re: Oracle performance and swapping on Tru 64

While people have different percentages as their thresholds, anytime a disk gets more than 30/40 percent busy you are starting to ask for trouble.

Your process "wants to do" IO to sometime that may be already busy servicing someone else's request. So you queue up and wait to "move the disk head away" from where the other process had last moved it so they that process gets (or writes) the data that it needed.

When you start getting into the percentages you are talking about it is definite trouble.

You may want to think about disk and subsystem placement issues as well as application changes. But I still recommend looking at getting and analyzing a 10046 trace before jumping to conclusions ( or at least to help you understand the relative impact of different factors ). Received on Mon Mar 20 2006 - 10:36:44 CST