LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (http://www.linuxquestions.org/questions/linux-general-1/)
-   -   Storage LUN utilization is 100% (http://www.linuxquestions.org/questions/linux-general-1/storage-lun-utilization-is-100-a-4175452908/)

Rantu 03-06-2013 01:24 AM

Storage LUN utilization is 100%
 
I have a oracle database server running in RAC mode. The underlying storage LUN's are of 2*2TB. When DBA importing data, the utilization of these LUN's reaches 100% in iostat -x command. As per DBA the performance is a bit slow.

Can someone explain where the problem might be? What should be the optimal utilization % for a storage LUN? Do I need to increae the count of the LUN's ? say 4*1TB ?

TB0ne 03-07-2013 10:58 AM

Quote:

Originally Posted by Rantu (Post 4905716)
I have a oracle database server running in RAC mode. The underlying storage LUN's are of 2*2TB. When DBA importing data, the utilization of these LUN's reaches 100% in iostat -x command. As per DBA the performance is a bit slow.

Can someone explain where the problem might be? What should be the optimal utilization % for a storage LUN? Do I need to increae the count of the LUN's ? say 4*1TB ?

Seriously?? Your DBA is importing data, and is wondering why the disks are busy? The disks are busy, because there is a lot of IO going on, due to the data import.

There is no way to tell you how to optimize it, since we don't know how the tables are laid out, what RAID level/BCV options you have on behind the scenes, or any of the other relevant information, including how large the import is, and if it's finishing. Best thing to do would be to work with Oracle, give them a trace, and see what they suggest.


All times are GMT -5. The time now is 06:30 AM.