We are running Oracle DB in RHEL (with raid 5) and having problems with disk performance. It takes ages for some queries and I suspect we have a problem with the disk hardware, because one of the disks crash and we replaced it and performance problems began after that. Why I think its not related to oracle and queries is that the same database dump on windows box does not have any performance problems and query execution is very fast.
I see a lot of errors in /var/log/messages
Oct 22 14:28:44 locdb kernel: hda: tray open
Oct 22 14:28:45 locdb kernel: end_request: I/O error, dev 03:00 (hda), sector 4
Oct 22 14:28:45 locdb kernel: hda: tray open
Oct 22 14:28:45 locdb kernel: end_request: I/O error, dev 03:00 (hda), sector 6
When I try to test wiht hdparm I get:
[root@locdb root]# hdparm -Tt /dev/hda
read() failed: Input/output error
Timing buffered disk reads: read() failed: Input/output error
Would appreciate any troubleshooting tips for a newbie here.