HI All,
I have a storage array with 40 disks of 15k RPM in RAID 1 setup. I have couple of DB sitting in the entire storage. DB sizes are 3TBs and 1.5 TB.
I have couple of SSDs sitting in the storage controller
Questions:
At any point in time , i am only seeing 100 IOPS being fired for single block index reads
Through put is 100 iops*8kb=800KB/Sec almost 1MB is read per second and if i need to read a 100MB of data from disk , it takes almost 100 seconds to fetch the 100MB.
At the same i can fire 5 sessions and each does the work at same speed, 5MB is read but for different stmts.
Average latency of the single block read from the storage is <8ms
The above statistics are from enterprise manager and its an accurate representation.
Q1. Should i add more disks to increase more thourghput
Q2. Raid 1 is not ideal, but its already setup, SHould i break the raid and configure RAID10 or RAID 5
REDOLOG/Archive log all share the same storage with different luns carved and presented.
Oracle 11.2.0.3 with ASM
Any suggestions are welcome.