Hello
My Environment:
- Oracle 11.2.0.3 EE
- SuSE Enterprise Linux 11 SP1, 64 Bit
- ASM Diskgroups on RAW Luns (2 per group) in Hitachi Disk Storage
- DB-Server: HP DL380 G7
I like to switch ASM disks from disk to ssd's, direct attach to via HP DS2700 enclosure:
- Diskgroup +DATA
5x400GB Enterprise SSD, RAID 5, 1.6TB raw capacity
used for Redo, Datafiles - Diskgroup +ARCH
4x400GB Enterprise SSD, RAID0+1, 800GBraw capacity
used for Redo, Archives, Flash Recovery Area
As I could understand SSD technology so far, SSDs have a livetime, meaning there is a guaranteed amount of data which can be read/written on it. My aim is to engineer a system that does not have the point of failure of two broken ssd's in the same RAID group.
- How can I determine the total bytes written/read to the ASM diskgroups so far?
My idea was to dermine ASM block size (select block_size from v$asm_diskgroup) and then look at total reads and writes columns via iostat command in asmcmd. I assume these values are since last ASM startup. - Is there a way to determine IOPS per diskgroup?
Thanks
scsi