ASM Layout: Need some IO distribution input
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 31 Jan 2013 06:49:54 -0600
Currently our part of our ASM disk layout looks like the below.
Since I'm new to ASM and RAC, I'm wondering if I could improve this layout
(that I inherited) - I'm not sure how many physical devices make up each 67 /
134 GB RAW device in the EMC array. I believe they are striped in array over
many disks but not positive on that.
I was wondering if it would make more sense to combine any of these groups, or
to definitely *not* combine any of these groups?
Currently we do see write latencies to the redo log groups and I was thinking
about 1 of 2 options:
a.) adding a 67 GB lun to each redo log disk group OR
b.) combining the redo log group with the larger data group luns
It seems [to me] that combining the disk groups with the larger DATA disk group
would reduce the IO sizes to each RAW device inside the group and perhaps
improve write times.
A lot of my theory is based on older SAN technology so I'm not sure it applies
here.
Any issues/suggestions come to mind when seeing a layout like this?
Chris
(Formatted version)
http://codepaste.net/gby4zb
Disk Group Name Path File Name File
Size (MB) Used Size (MB) Pct. Used
------------------------ ------------------ ------------------------------
-------------- -------------- ---------
DG_CCMNASP1_ARCHIVE_01 /dev/raw/raw70 DG_CCMNASP1_ARCHIVE_01_0050
138,097 115,726 83.80
/dev/raw/raw71 DG_CCMNASP1_ARCHIVE_01_0051
138,097 115,739 83.81
/dev/raw/raw72 DG_CCMNASP1_ARCHIVE_01_0052
138,097 115,735 83.81
/dev/raw/raw73 DG_CCMNASP1_ARCHIVE_01_0053
138,097 115,784 83.84
/dev/raw/raw79 DG_CCMNASP1_ARCHIVE_01_0054
138,097 116,143 84.10
************************
-------------- --------------
690,485 579,127
DG_CCMNASP1_CONTROL1_01 /dev/raw/raw98 DG_CCMNASP1_CONTROL1_01_0050
2,155 209 9.70
************************
-------------- --------------
2,155 209
DG_CCMNASP1_CONTROL2_01 /dev/raw/raw99 DG_CCMNASP1_CONTROL2_01_0050
2,155 209 9.70
************************
-------------- --------------
2,155 209
DG_CCMNASP1_DATA_01 /dev/raw/raw83 DG_CCMNASP1_DATA_01_0052
69,044 49,001 70.97
/dev/raw/raw84 DG_CCMNASP1_DATA_01_0053
69,044 49,002 70.97
/dev/raw/raw85 DG_CCMNASP1_DATA_01_0054
69,044 49,001 70.97
/dev/raw/raw86 DG_CCMNASP1_DATA_01_0055
69,044 49,001 70.97
/dev/raw/raw87 DG_CCMNASP1_DATA_01_0056
69,044 49,001 70.97
/dev/raw/raw76 DG_CCMNASP1_DATA_01_0057
138,097 98,008 70.97
/dev/raw/raw96 DG_CCMNASP1_DATA_01_0058
69,044 49,002 70.97
/dev/raw/raw97 DG_CCMNASP1_DATA_01_0059
69,044 49,001 70.97
/dev/raw/raw74 DG_CCMNASP1_DATA_01_0060
138,097 98,007 70.97
/dev/raw/raw75 DG_CCMNASP1_DATA_01_0061
138,097 98,009 70.97
/dev/raw/raw77 DG_CCMNASP1_DATA_01_0062
138,097 98,008 70.97
/dev/raw/raw78 DG_CCMNASP1_DATA_01_0063
138,097 98,008 70.97
/dev/raw/raw102 DG_CCMNASP1_DATA_01_0064
138,097 98,006 70.97
/dev/raw/raw103 DG_CCMNASP1_DATA_01_0065
138,097 98,008 70.97
************************
-------------- --------------
1,449,987 1,029,063
DG_CCMNASP1_REDO_01 /dev/raw/raw81 DG_CCMNASP1_REDO_01_0051
69,044 46,137 66.82
************************
-------------- --------------
69,044 46,137
DG_CCMNASP1_REDO_02 /dev/raw/raw82 DG_CCMNASP1_REDO_02_0051
69,044 45,833 66.38
************************
-------------- --------------
69,044 45,833
DG_CCMNASP1_UNDO_TEMP_01 /dev/raw/raw88 DG_CCMNASP1_UNDO_TEMP_01_0050
69,044 51,222 74.19
/dev/raw/raw89 DG_CCMNASP1_UNDO_TEMP_01_0051
69,044 51,222 74.19
/dev/raw/raw90 DG_CCMNASP1_UNDO_TEMP_01_0052
69,044 51,222 74.19
/dev/raw/raw91 DG_CCMNASP1_UNDO_TEMP_01_0053
69,044 51,223 74.19
/dev/raw/raw92 DG_CCMNASP1_UNDO_TEMP_01_0054
69,044 51,223 74.19
/dev/raw/raw93 DG_CCMNASP1_UNDO_TEMP_01_0055
69,044 51,223 74.19
/dev/raw/raw94 DG_CCMNASP1_UNDO_TEMP_01_0056
69,044 51,223 74.19
/dev/raw/raw95 DG_CCMNASP1_UNDO_TEMP_01_0057
69,044 51,224 74.19
************************
-------------- --------------
552,352 409,782
Chris Taylor
Oracle DBA
Parallon IT&S
--
//www.freelists.org/webpage/oracle-l
Other related posts:
