RE: DISK LAYOUT
Well I think it's time for you to start reading papers discussing OFA (Optimal Flexible Architecture). http://technet.oracle.com/doc/oracle8i_816/linux_816/unixdoc/a82848/a82846/a ppa_ofa.htm The above link is for the LINUX OFA document, but the concepts are the same, and you will probably find one specific to your platform simply by searching at http://otn.oracle.com Regarding RAID - there is a good paper (already mentioned on the list lately) by Gaja at www.quest.com HTH Mark P.S. Actually, thinking about it - you already asked this? How about having a read as people have already suggested? There is only a finite amount that we can put in to an email (hey - we all have to work too!). -Original Message- Sent: 03 December 2001 15:15 To: Multiple recipients of list ORACLE-L Hi, We have to performance benchmark test for our application . We have to check only scalibiliy and performance and not much concern for reliablity. We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot disks).4 400MHZ cpu's Expected database size is 250G.. 1) Which raid level to use ...only for performance so may be no mirroring.. 2) did i have to split hard disks on 2 sets for indexes and tables or single set of RAID 0 etc... 3) Where to place the log files , control files, oracle software , OS , tablespaces - System , Users(tables) , Temp, Indx (Indexes) , Rbs , Tools. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DISK LAYOUT & RAID LEVEL
Hi Harvinder, If I were you I would - put OS and Oracle executables on a RAID1 volume with minimal raid block size - put redo log files in "chess order" on two dedicated RAID1 volumes (the odd redo groups locate on the first volume and the even redo groups locate on the second RAID1 volume). It seems 9Gb disks are more suited for that goal. I'm still not sure what raid block size should be choosen for these volumes. I assume it should be minimal and cover your average redo write size. - make a RAID1 volume for archive redo logs, let say 2x36 (depends on the volume of your archive logs) The most difficult decision I think is how to locate your index, data, rbs, temp and what stripe size to choose. In general it depends on your application. In your case I would prefer to have several RAID volumes in order to be able to balance disk loading on data and indexes. Levels RAID1+0 or RAID0+1 are more suitable here. There are several articles at Steve Adams' site www.ixora.com.au and good Gaja's article about RAID at www.quest.com I think 25-30% of RAM is a good start point for SGA. Regards, Ed > Hi, > > We have to do benchmarks tests(scalability,performance) for our product and > have machine with following > configuration..We dont have experience for large size databases layout. > It will be greatly appreciated if someone points out from his experience: > > 1) Which raid level to use for which files and on how many disks. > 2) As we have 10 disks what file to place on which disk. > 3) How much RAM to use for SGA.(this is database dedicated machine) > > Server - E3500 with 2 internal boot disks (18GB) > 4 400MHZ/8MB ecache and 2 GB ram > 2 I/O boards > > Arrays - HDS 9210 Fiber channel array with 10 36GB disks @ 10K RPM with > 5.7 read and 6.5 write seek. > Sun A5200 with 22 9GB Seagate drives @ 10KRPM with 5.4 read and > 6.2 write seek. > > HDS is a hardware based array and the A5200 is software with Veritas VM > > Thanks > -Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder Singh > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DISK LAYOUT & RAID LEVEL
http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf Harvinder SinghTo: Multiple recipients of list ORACLE-L ngh cc: @MetraTech.coSubject: DISK LAYOUT & RAID LEVEL m> Sent by: root 11/30/2001 10:35 AM Please respond to ORACLE-L Hi, We have to do benchmarks tests(scalability,performance) for our product and have machine with following configuration..We dont have experience for large size databases layout. It will be greatly appreciated if someone points out from his experience: 1) Which raid level to use for which files and on how many disks. 2) As we have 10 disks what file to place on which disk. 3) How much RAM to use for SGA.(this is database dedicated machine) Server - E3500 with 2 internal boot disks (18GB) 4 400MHZ/8MB ecache and 2 GB ram 2 I/O boards Arrays - HDS 9210 Fiber channel array with 10 36GB disks @ 10K RPM with 5.7 read and 6.5 write seek. Sun A5200 with 22 9GB Seagate drives @ 10KRPM with 5.4 read and 6.2 write seek. HDS is a hardware based array and the A5200 is software with Veritas VM Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk Layout Document
Jesse - Yes, that is my situation. Most of the textbooks still talk about stand-alone disk drives, while most of us are using RAID. A RAID set handles much more throughput than a stand-alone disk and incorporates many disk drives within itself. So the hardware people certainly won't buy 22 RAID sets. When I start talking about spreading I/O to more RAID sets, the response I receive is that the RAID set isn't anywhere near its I/O capacity. Usually I have 2 RAID sets for the bulk of the data, plus additional drives/sets for redo, etc. If anyone can point me to a document that says there are advantages to more RAID sets, I would be very interested. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 15, 2001 11:40 AM To: Multiple recipients of list ORACLE-L 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 [EMAIL PROTECTED] 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 --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Bingo! Chapter 4. I knew I had read the variations somewhere. > > Thanks for the assist. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 14, 2001 3:32 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: RE: Disk Layout Document > > > > > > I believe the Oracle DBA Handbook by Kevin Loney has that... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT
RE: Disk Layout Document
I do have them on separate disks. On separate volumn groups and never does a disk work in two volumn groups or mount points. I mean I have more then 6 disks. It would be a minimum of 11 (I do not mirror the hot backup mount point). -Original Message- Sent: Thursday, November 15, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Is there an advantage to using multiple mount points even if they're not multiple disks? Aren't logical vols spread out over multiple physical disks anyway? Kimberly SmithTo: Multiple recipients of list ORACLE-L th cc: @gmd.fujitsu.Subject: RE: Disk Layout Document com> Sent by: root 11/15/2001 11:20 AM Please respond to 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 --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Bingo! Chapter 4. I knew I had read the variations somewhere. > > Thanks for the assist. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 14, 2001 3:32 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: RE: Disk Layout Document > > > > > > I believe the Oracle DBA Handbook by Kevin Loney has that... > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Elkins > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern
RE: Disk Layout Document
Is there an advantage to using multiple mount points even if they're not multiple disks? Aren't logical vols spread out over multiple physical disks anyway? Kimberly SmithTo: Multiple recipients of list ORACLE-L th cc: @gmd.fujitsu.Subject: RE: Disk Layout Document com> Sent by: root 11/15/2001 11:20 AM Please respond to 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 --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Bingo! Chapter 4. I knew I had read the variations somewhere. > > Thanks for the assist. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 14, 2001 3:32 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: RE: Disk Layout Document > > > > > > I believe the Oracle DBA Handbook by Kevin Loney has that... > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Elkins > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, C
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 [EMAIL PROTECTED] 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 --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Bingo! Chapter 4. I knew I had read the variations somewhere. > > Thanks for the assist. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 14, 2001 3:32 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: RE: Disk Layout Document > > > > > > I believe the Oracle DBA Handbook by Kevin Loney has that... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk Layout Document
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 --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Bingo! Chapter 4. I knew I had read the variations somewhere. > > Thanks for the assist. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 14, 2001 3:32 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: RE: Disk Layout Document > > > > > > I believe the Oracle DBA Handbook by Kevin Loney has that... > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Elkins > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk Layout Document
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 --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Bingo! Chapter 4. I knew I had read the variations somewhere. > > Thanks for the assist. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 14, 2001 3:32 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject: RE: Disk Layout Document > > > > > > I believe the Oracle DBA Handbook by Kevin Loney has that... > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Elkins > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Disk Layout Document
dba handbook -- Kevin had a section on you should have 22 disks, then no, 17, then no 9.. --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Listers, > > Okay, I've been googling for about an hour now and can't find it. It > seems > like I remember seeing a white paper, note, or some sort of reference > detailing "preferred" file layouts based on different number of disks > -- > e.g. 4 disks try this, with 5 disks try that. > > Does that ring a bell? And if so, can anyone send me the link? In the > meantime, back to my google gun. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Elkins > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Disk Layout Document
Larry, There is some discussion of this in the "Designing and Tuning for Performance" docs at: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/ch20_io.htm#11672 URL will probably wrap. I'm sure this isn't exactly what you want, but its a good start. Scott Shafer SATX Larry Elkins wrote: > > Listers, > > Okay, I've been googling for about an hour now and can't find it. It seems > like I remember seeing a white paper, note, or some sort of reference > detailing "preferred" file layouts based on different number of disks -- > e.g. 4 disks try this, with 5 disks try that. > > Does that ring a bell? And if so, can anyone send me the link? In the > meantime, back to my google gun. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Elkins > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk Layout Document
Bingo! Chapter 4. I knew I had read the variations somewhere. Thanks for the assist. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 14, 2001 3:32 PM > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > Subject: RE: Disk Layout Document > > > I believe the Oracle DBA Handbook by Kevin Loney has that... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that... -Original Message- Sent: Wednesday, November 14, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Listers, Okay, I've been googling for about an hour now and can't find it. It seems like I remember seeing a white paper, note, or some sort of reference detailing "preferred" file layouts based on different number of disks -- e.g. 4 disks try this, with 5 disks try that. Does that ring a bell? And if so, can anyone send me the link? In the meantime, back to my google gun. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk layout
>> From: "Steven Hovington" <[EMAIL PROTECTED]> >> Date: Wed, 3 Oct 2001 14:33:52 +0100 >> Subject: Disk layout >> >>Could anyone please point me towards documentation which discusses optimum >>disk layouts for Oracle databases. Some other useful sources: http://www.ipass.net/~davesisk/oont_config_bpft.htm http://www.geocities.com/Colosseum/1190/oracle/ORACLE_NT_CONFIG.pdf This one contains other references! Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Disk layout
Here's a good one: http://www.quest.com/whitepapers/Raid1.pdf Steven Hovington wrote: > > Could anyone please point me towards documentation which discusses optimum > disk layouts for Oracle databases. > > Thanks in advcance. > > Steven. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Hovington > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk layout
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
Re: Disk layout
It's real easy, pay close attention... Put every Oracle object on it's own disk drive and controller. If your table is too huge and you must use more than one disk drive, then make sure that each disk drive has it's own disk bus. Larry will then come to your site and run benchmark testing and will praise you on how well your database performs. Regards, Satar --- Steven Hovington <[EMAIL PROTECTED]> wrote: > Could anyone please point me towards documentation > which discusses optimum > disk layouts for Oracle databases. > > Thanks in advcance. > > Steven. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Steven Hovington > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk layout
DBA Handbook if I remember had a nice section on disk layouts starting out with preferred and scaled down. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, October 03, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Could anyone please point me towards documentation which discusses optimum disk layouts for Oracle databases. Thanks in advcance. Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Disk layout for datafiles
which is not the same as Oracle Freakin Aborted. joe >>> [EMAIL PROTECTED] 07/03/01 02:23PM >>> I thought OFA was short for Oh Freakin Eh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 1:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles Pronounced "ofa?" I've always pronounced it "Oh Eff Ay." Does this say something about my certification? Or is it a 9i thing? :-) I need a job. Pronounced "job." Yosi -Original Message-From: Guy Hammond [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 4:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles It's called the Optimal Flexible Architecture, or OFA (pronounced "ofa"). A Google search brings up lots of resources on it: http://www.google.com/search?q=Optimal+Flexible+Architecture&hl=xx-bork&lr=lang_en g -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 7:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles under five or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
RE: Disk layout for datafiles
I thought OFA was short for Oh Freakin Eh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 1:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles Pronounced "ofa?" I've always pronounced it "Oh Eff Ay." Does this say something about my certification? Or is it a 9i thing? :-) I need a job. Pronounced "job." Yosi -Original Message-From: Guy Hammond [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 4:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles It's called the Optimal Flexible Architecture, or OFA (pronounced "ofa"). A Google search brings up lots of resources on it: http://www.google.com/search?q=Optimal+Flexible+Architecture&hl=xx-bork&lr=lang_en g -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 7:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles under five or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
RE: Disk layout for datafiles
Pronounced "ofa?" I've always pronounced it "Oh Eff Ay." Does this say something about my certification? Or is it a 9i thing? :-) I need a job. Pronounced "job." Yosi -Original Message-From: Guy Hammond [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 4:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles It's called the Optimal Flexible Architecture, or OFA (pronounced "ofa"). A Google search brings up lots of resources on it: http://www.google.com/search?q=Optimal+Flexible+Architecture&hl=xx-bork&lr=lang_en g -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 7:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles under five or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
RE: Disk layout for datafiles
It's called the Optimal Flexible Architecture, or OFA (pronounced "ofa"). A Google search brings up lots of resources on it: http://www.google.com/search?q=Optimal+Flexible+Architecture&hl=xx-bork&lr=lang_en g -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 7:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles under five or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
RE: Disk layout for datafiles
Thank you Ross. -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Disk layout for datafiles Search under "OFA" or "Optimal Flexible Architecture" for a wealth of information. -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 2:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles under five or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
RE: Disk layout for datafiles
Search under "OFA" or "Optimal Flexible Architecture" for a wealth of information. -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 2:31 PMTo: Multiple recipients of list ORACLE-LSubject: Disk layout for datafiles I found and then lost a Metalink document about laying out datafiles under five or seven mount points. Does anyone have a link to this note, or any regarding datafile naming conventions/path layouts for unix/sun? Thanks, Linda
