Optimal Disk Layout??

2001-09-21 Thread Walter K
Hi, I'm encuntering a relatively high iowait percentage when my hot backups are running. The platform is Sun (E420 2cpu running SunOS 5.7) with an A1000 disk array (8 9Gb drives, hardware Raid-5). The array is one volume and all DB components (redo, archive, data, index, system, etc.) are on the

RE: Optimal Disk Layout??

2001-09-21 Thread Christopher Spence
1. depends on the stripe width, data may be on one or many drives, parity will always get written to all. 2. I believe your performance will be better; you have 6 drives for data, and 4 for archive/redo. That equates to 12 drives over the previous 8. However, you were using all eight for

RE: Optimal Disk Layout??

2001-09-21 Thread Walter K
Isn't it 3 drives for data, not 6, because of the mirroring? I agree, mirroring the extra 4 (9Gb) drives isn't necessary because this can be accomplished via the DB config. Veritas is also being used on the existing array and the sys admin seems to think that we've got extra overhead for that on

Re: Optimal Disk Layout??

2001-09-21 Thread satar naghshineh
Hi Walter, It looks like you're having a bottleneck on your controller during a hot backup. This is a result of (1) reading the data then (2) writing the data and compressing the data within the same controller. To answer your questions: 1. During RAID 5, all your disks are being written to and