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 ?
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 04:52 PM.|