Re: 30GB table: Hardware performance issue ?

We are running on Oracle Entreprise Edition 8.1.7. The index is IDX_HITORY(TimeStamp DATE, ID NUMBER) and it has 23% selectivity.

I have maybe included a bad exemple in this post. The IN clause doesn't cause much problem. Oracle handles it very well. Any query that runs on this HISTORY table and uses the Index, returns 11000 rows in about 27-33 seconds. Actually the performance of the read depends on the number of physical read.

The CPU usage is OK 10% however the Raid 1 is running 90%.

I think that we are IO bound. Received on Mon Mar 03 2003 - 21:48:10 CST