RE: Number of File systems to use.
Thank you very much Robert Freeman for your opinion. I am half way through your book of 9i new features. It is very good. Could some one else give some opinion on the need to spread IO even when using EMC storage please. --- Freeman, Robert [EMAIL PROTECTED] wrote: I'd stick to the idea of fewer file systems. Here is why: 1. Shorter system reboot time (fsck doesn't take as long with fewer file systems). 2. Fewer file systems reduce the risk of Inode corruption. 3. Fewer file system easier to manage. As for EMC and IO and performance, I'm not sure I'm the best person to address that question. RF Robert G. Freeman Author Oracle9i New Features by Oracle Press Mastering Oracle8i By Sybex -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 8:58 AM To: LazyDBA.com Discussion Subject: Number of File systems to use. All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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).
Number of File systems to use.
All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Number of File systems to use.
My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:57 AM Subject: Number of File systems to use. All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Number of File systems to use.
Now they have hardware striping. Regards, Waleed -Original Message- Sent: Wednesday, April 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:57 AM Subject: Number of File systems to use. All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Khedr, Waleed 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: Number of File systems to use.
Waleed, That's interesting. I just looked at the emc site and still do not see anything that would lead me to believe that they support hardware striping except for the IBM Sequential Data Striping. This was for the Symetrix 3000, 5000 8000 line. I would be keenly interested to know as we have many TB here of EMC and all of it is software striped. What product line are you referring to? When did they start? Thanks, Bill --- Khedr, Waleed [EMAIL PROTECTED] wrote: Now they have hardware striping. Regards, Waleed -Original Message- Sent: Wednesday, April 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:57 AM Subject: Number of File systems to use. All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Khedr, Waleed 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!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass 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
RE: Number of File systems to use.
Look at the attached email message. There was a thread of discussion about this a month ago. Anyway I am going to test it on a small scale in one of my projects. I was told that 1MB (one track) stripe size is the smallest efficient size we should have b/c EMC will read 1MB anyway (one track) even if you need less. Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, April 24, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Waleed, That's interesting. I just looked at the emc site and still do not see anything that would lead me to believe that they support hardware striping except for the IBM Sequential Data Striping. This was for the Symetrix 3000, 5000 8000 line. I would be keenly interested to know as we have many TB here of EMC and all of it is software striped. What product line are you referring to? When did they start? Thanks, Bill --- Khedr, Waleed [EMAIL PROTECTED] wrote: Now they have hardware striping. Regards, Waleed -Original Message- Sent: Wednesday, April 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:57 AM Subject: Number of File systems to use. All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Khedr, Waleed 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: Number of File systems to use.
Try this link: https://powerlink.emc.com/MediumFreq/21110_Symmetrix_3930_5930_Installation_ Manual.pdf starting from page 155 Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, April 24, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Look at the attached email message. There was a thread of discussion about this a month ago. Anyway I am going to test it on a small scale in one of my projects. I was told that 1MB (one track) stripe size is the smallest efficient size we should have b/c EMC will read 1MB anyway (one track) even if you need less. Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, April 24, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Waleed, That's interesting. I just looked at the emc site and still do not see anything that would lead me to believe that they support hardware striping except for the IBM Sequential Data Striping. This was for the Symetrix 3000, 5000 8000 line. I would be keenly interested to know as we have many TB here of EMC and all of it is software striped. What product line are you referring to? When did they start? Thanks, Bill --- Khedr, Waleed [EMAIL PROTECTED] wrote: Now they have hardware striping. Regards, Waleed -Original Message- Sent: Wednesday, April 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:57 AM Subject: Number of File systems to use. All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse. The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems. 1: 50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks. 2: 20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks. Question.: 1:Since we are using EMC do we need to pay so much attention to spreading IO. 2: Any problems/advantages in having too many file systems. Please give all your opinions. __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists