| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Disk Layout Document
After many DB copies, loads, reloads, upgrades, etc., I've decided that the 22-disk layout just doesn't work for us. With only two 4-way stripe sets, we get vastly superior I/O thruput that more than compensates for any contention on any of the stripes.
Yes, yes, I understand that with mirroring the total drive count is 16. But since this is only a volatile test system there's no need for mirroring, archiving, or duplexing for recovery. With another stripe/mirror (RAID 10 or 0+1 -- no need to get back to that discussion) of 6 or 8 drives total for the archiving and maybe a duplexed controlfile, I still say that setup will smoke an Oracle-sanctioned Kevin Loney 22-disk layout. At least it does for our DB and environment.
Think about it: If a single drive housing a single datafile can pop 100-200 I/Os/sec, that same datafile on a 4-way stripe can hit in the thousands (w/caching and tuning). Of course, mutiply this by several datafiles, redos, controlfiles, and you've got a really fun physical layout project to minimize contention at peak operating times.
Hey, it can't work for everyone. But some may see the huge performance advantage we've seen by using RAID instead of single drives for physical DB layout.
Just my $.02
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Thursday, November 15, 2001 10:21
To: Multiple recipients of list ORACLE-L
Every time they ask for a new database I try that 22 disk thing also. I also settle for 6 mount points (not 6 disks). Its still fun to try though. Especially when we hire new people.
-----Original Message-----
Sent: Wednesday, November 14, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L
the very first time I ever saw Kevin present, he was talking about that. I went out and bought the DBA Handbook and came home to the operations people saying "I need 22 disks"
when they picked themselves up off the floor I said "okay, I can get away with 17"
again, I waited until they stopped laughing and said "can I get 9?"
I settled for 6
then I kept reading the book and emailing kevin with the typos I would find. And that dear ones, is how Kevin Loney and I met and became friends.
He got his revenge for my bothering him though -- he got me to co-author a book :)
Rachel
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 15 2001 - 12:09:11 CST
 |
 |