Hi All:
We have 4 similar databases (8.1.7.4) on 4 different Sun Enterprise 3500 with Solaris 8. All these servers have same number of disks and all the data files are spread across the multiple disks. We have same number of users on all 4 databases and I can not say the database access is same but almost.
All the servers are on the same patch level OS wise. Same patch level Database wise. We used to have same amount of I/O on all the databases and we started having high I/O on one devise (A1000) in One server. On this devise we do not have other files except oracle datafiles. For sure we did not install any patches on the server. Verified all the objects, All the objects are valid and were analyzed.
Is there a way that I can find which process is causing this high I/O. We do not have anything else other than the OS and the Oracle Database on these servers.
Few other questions...
1) What can cause High I/O on devise,....Can a Corrupted Datafile?..
I have verified the datafiles with DBV, None of the datafiles have any problem.
2) Is there a way to find which process is causing this high I/O through a UNIX command?
3) If I rebuild all Indexes Will that help?
Thanks in Advance,
vbadba.