Yeah, that's the thing I get notices saying I need to stripe my data across multiple disks because the I/O read times are slow :) the data is already striped.
I just had one pop up again this morning and since it's not *critical* meaning the databases aren't down, the sysadmin has done nothing about it. So I'm trying to see if there is anything else I can do on my end to relieve the slowness.
On Sep 29, 2010, at 10:25 AM, Andrew Kerber wrote:
There are quite a few Oracle db's running on that configuration. What do your AWR reports say about your IO service time? Is IO among your top 5 wait events most of the time?On Wed, Sep 29, 2010 at 9:05 AM, Betsy Ward <wardbe@xxxxxxxxxxx> wrote: Does anyone on this list have their Oracle databases sitting on a NAS that runs through ISCSI? If yes, I'm curious as to the performance you are experiencing with it and whether you can share that with me possibly how you tuned your database to work on such a setup?We are running Oracle 11g db servers on Red Hat 5.3 connected to a Sun X4540 "Thor" running nexenta. We moved to this configuration about a year ago and performance has not been good. The X4540 also has our email servers storage on it, so when they tuned it they tuned it for write times to be fast, not reads.But I'm wondering if there are things I can do from the database side to be able to speed up the performance because of the slowness on the hardware side, or if the sysadmin just needs to get the thing tuned well for reads so that Oracle is happy?TIA, ---------------------------------------- Betsy Ward Database Administrator Earlham College, Drawer 14 801 National Road West Richmond, IN 47374 Ph 765-983-1712 Fax 765-983-1253 ---------------------------------------- -- //www.freelists.org/webpage/oracle-l -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
---------------------------------------- Betsy Ward Database Administrator Earlham College, Drawer 14 801 National Road West Richmond, IN 47374 Ph 765-983-1712 Fax 765-983-1253 ----------------------------------------"Go away before I replace you with a very small and efficient shell script..."