Re: Oracle on a SAN.... Good, Bad or Proceed with caution?
Scott (and others), I apologize, all I was given regarding this document was a hard copy and based on confidentiality footers, I'm don't think I'm allowed to distribute it. However, if you're on an EMC system now, I'd call or e-mail your EMC rep and ask for it. If it works as well as described, it will only make them look better. >>> [EMAIL PROTECTED] 03/07/03 12:44PM >>> I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. >>> [EMAIL PROTECTED] 03/07/03 10:55AM >>> Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: >Amen! For several years we heard from EMC reps, don't worry about it, >don't worry about it, then recently we we're given a white paper from EMC >on striping for Oracle. > > > >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> >SAN is fine as long as you keep track of what's mapping to what physical >disks. I for one don't believe the SAN vendors that say their caching takes >care of performance for you and you don't need to worry about where data is >stored physically. Place datafiles the same way you would for local storage >and you will do well - striped, with data, indexes, temp, and rollback >physically separated. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, March 06, 2003 4:39 PM > > > > Hello, > > > > We are currently spec'ing out hardware for our new ERP system. It is > > either going to be Peoplesoft or Oracle. We are also debating on using a > > SAN rather than attached storage. I'm just looking for any > > positives/negatives/rules of thumb I should be aware of when running >Oracle > > on a SAN architecture provided that management goes that way. The SAN box > > we are looking at right now is the EVA3000 from HP (although this isn't a > > definite) not sure if this matters. > > > > TIA, > > -Scott Stefick > > > > ** > > Scott Stefick > > UNIX Systems Administrator > > Oracle Certified Professional DBA > > Wm. Rainey Harper College > > 847.925.6130 > > ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Scott Stefick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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.net >-- >Author: Chuck Hamilton > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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.net >-- >Author: Darrell Landrum > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
Re: Oracle on a SAN.... Good, Bad or Proceed with caution?
We have had I/O issues in the last few months on EMC disks that were corrected by physically relocating filesystems. With no other changes we saw response times cut in half by simply splitting the filesystems from busy databases onto different physical devices within the SAN. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 07, 2003 3:19 PM > We ran ORacle on NETapps... about a 100 Production Databases and I spent a > massive > amount (6months) of time verifying that Certain applications were not > hindered by the > Netapp SAN... There was alot of doubt buy everyone... but in the end it was > clear the > San preformed fine..and all the glitches proved to be solved by application > redesign. > > This vendor told me everything was journalled in memory and pointers were > changing rather > than direct hitting disk becoming an issue. > > I looked at the specs of the disks...ie megs per second capability.. and > compare that > to what your database is out putting per mount point/ie disk. > > Bottom line... I was a doubter ...but converted :) > > Brian Spears > > > > > > > -Original Message- > Sent: Friday, March 07, 2003 11:55 AM > To: Multiple recipients of list ORACLE-L > > > Darrell, > > Could I have a copy of that white paper if you still have it? > > Thanks, > Scott > > > At 08:19 AM 3/7/03 -0800, you wrote: > >Amen! For several years we heard from EMC reps, don't worry about it, > >don't worry about it, then recently we we're given a white paper from EMC > >on striping for Oracle. > > > > > > >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> > >SAN is fine as long as you keep track of what's mapping to what physical > >disks. I for one don't believe the SAN vendors that say their caching takes > >care of performance for you and you don't need to worry about where data is > >stored physically. Place datafiles the same way you would for local storage > >and you will do well - striped, with data, indexes, temp, and rollback > >physically separated. > > > >- Original Message - > >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > >Sent: Thursday, March 06, 2003 4:39 PM > > > > > > > Hello, > > > > > > We are currently spec'ing out hardware for our new ERP system. It is > > > either going to be Peoplesoft or Oracle. We are also debating on using > a > > > SAN rather than attached storage. I'm just looking for any > > > positives/negatives/rules of thumb I should be aware of when running > >Oracle > > > on a SAN architecture provided that management goes that way. The SAN > box > > > we are looking at right now is the EVA3000 from HP (although this isn't > a > > > definite) not sure if this matters. > > > > > > TIA, > > > -Scott Stefick > > > > > > ** > > > Scott Stefick > > > UNIX Systems Administrator > > > Oracle Certified Professional DBA > > > Wm. Rainey Harper College > > > 847.925.6130 > > > ** > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Scott Stefick > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > 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.net > >-- > >Author: Chuck Hamilton > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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.net > >-- > >Author: Darrell Landrum > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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
RE: Oracle on a SAN.... Good, Bad or Proceed with caution?
-Original Message- Sent: Friday, March 07, 2003 4:44 PM To: Multiple recipients of list ORACLE-L NetApp SAN? My understanding of NetApps was that is strictly NAS: Network Attached Storage. Basically, JBOD with NIC. SAN's offer quite a few more management and configuration options than NAS. Jared >There is a lot more to NetApp's Filer than JBOD with a NIC. We looked at both - SAN and NAS as done by NetApp one year later we're sold on NetApp. NetApp has all of the management/DR features we'll need, and some of the NetApp specific features have saved our collective tails on a few occasions. YMMV, but for an organization that's our size, SAN was overkill. brian< -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle on a SAN.... Good, Bad or Proceed with caution?
NetApp SAN? My understanding of NetApps was that is strictly NAS: Network Attached Storage. Basically, JBOD with NIC. SAN's offer quite a few more management and configuration options than NAS. Jared "Spears, Brian" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/07/2003 12:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle on a SAN.... Good, Bad or Proceed with caution? We ran ORacle on NETapps... about a 100 Production Databases and I spent a massive amount (6months) of time verifying that Certain applications were not hindered by the Netapp SAN... There was alot of doubt buy everyone... but in the end it was clear the San preformed fine..and all the glitches proved to be solved by application redesign. This vendor told me everything was journalled in memory and pointers were changing rather than direct hitting disk becoming an issue. I looked at the specs of the disks...ie megs per second capability.. and compare that to what your database is out putting per mount point/ie disk. Bottom line... I was a doubter ...but converted :) Brian Spears -Original Message- Sent: Friday, March 07, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: >Amen! For several years we heard from EMC reps, don't worry about it, >don't worry about it, then recently we we're given a white paper from EMC >on striping for Oracle. > > > >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> >SAN is fine as long as you keep track of what's mapping to what physical >disks. I for one don't believe the SAN vendors that say their caching takes >care of performance for you and you don't need to worry about where data is >stored physically. Place datafiles the same way you would for local storage >and you will do well - striped, with data, indexes, temp, and rollback >physically separated. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, March 06, 2003 4:39 PM > > > > Hello, > > > > We are currently spec'ing out hardware for our new ERP system. It is > > either going to be Peoplesoft or Oracle. We are also debating on using a > > SAN rather than attached storage. I'm just looking for any > > positives/negatives/rules of thumb I should be aware of when running >Oracle > > on a SAN architecture provided that management goes that way. The SAN box > > we are looking at right now is the EVA3000 from HP (although this isn't a > > definite) not sure if this matters. > > > > TIA, > > -Scott Stefick > > > > ** > > Scott Stefick > > UNIX Systems Administrator > > Oracle Certified Professional DBA > > Wm. Rainey Harper College > > 847.925.6130 > > ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Scott Stefick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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.net >-- >Author: Chuck Hamilton > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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.net >-- >Author: Darrell Landrum > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051
RE: Oracle on a SAN.... Good, Bad or Proceed with caution?
We ran ORacle on NETapps... about a 100 Production Databases and I spent a massive amount (6months) of time verifying that Certain applications were not hindered by the Netapp SAN... There was alot of doubt buy everyone... but in the end it was clear the San preformed fine..and all the glitches proved to be solved by application redesign. This vendor told me everything was journalled in memory and pointers were changing rather than direct hitting disk becoming an issue. I looked at the specs of the disks...ie megs per second capability.. and compare that to what your database is out putting per mount point/ie disk. Bottom line... I was a doubter ...but converted :) Brian Spears -Original Message- Sent: Friday, March 07, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: >Amen! For several years we heard from EMC reps, don't worry about it, >don't worry about it, then recently we we're given a white paper from EMC >on striping for Oracle. > > > >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> >SAN is fine as long as you keep track of what's mapping to what physical >disks. I for one don't believe the SAN vendors that say their caching takes >care of performance for you and you don't need to worry about where data is >stored physically. Place datafiles the same way you would for local storage >and you will do well - striped, with data, indexes, temp, and rollback >physically separated. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, March 06, 2003 4:39 PM > > > > Hello, > > > > We are currently spec'ing out hardware for our new ERP system. It is > > either going to be Peoplesoft or Oracle. We are also debating on using a > > SAN rather than attached storage. I'm just looking for any > > positives/negatives/rules of thumb I should be aware of when running >Oracle > > on a SAN architecture provided that management goes that way. The SAN box > > we are looking at right now is the EVA3000 from HP (although this isn't a > > definite) not sure if this matters. > > > > TIA, > > -Scott Stefick > > > > ** > > Scott Stefick > > UNIX Systems Administrator > > Oracle Certified Professional DBA > > Wm. Rainey Harper College > > 847.925.6130 > > ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Scott Stefick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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.net >-- >Author: Chuck Hamilton > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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.net >-- >Author: Darrell Landrum > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---
Re: Oracle on a SAN.... Good, Bad or Proceed with caution?
That's great! Thanks a ton. -Scott At 10:44 AM 3/7/03 -0800, you wrote: I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. >>> [EMAIL PROTECTED] 03/07/03 10:55AM >>> Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: >Amen! For several years we heard from EMC reps, don't worry about it, >don't worry about it, then recently we we're given a white paper from EMC >on striping for Oracle. > > > >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> >SAN is fine as long as you keep track of what's mapping to what physical >disks. I for one don't believe the SAN vendors that say their caching takes >care of performance for you and you don't need to worry about where data is >stored physically. Place datafiles the same way you would for local storage >and you will do well - striped, with data, indexes, temp, and rollback >physically separated. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, March 06, 2003 4:39 PM > > > > Hello, > > > > We are currently spec'ing out hardware for our new ERP system. It is > > either going to be Peoplesoft or Oracle. We are also debating on using a > > SAN rather than attached storage. I'm just looking for any > > positives/negatives/rules of thumb I should be aware of when running >Oracle > > on a SAN architecture provided that management goes that way. The SAN box > > we are looking at right now is the EVA3000 from HP (although this isn't a > > definite) not sure if this matters. > > > > TIA, > > -Scott Stefick > > > > ** > > Scott Stefick > > UNIX Systems Administrator > > Oracle Certified Professional DBA > > Wm. Rainey Harper College > > 847.925.6130 > > ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Scott Stefick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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.net >-- >Author: Chuck Hamilton > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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.net >-- >Author: Darrell Landrum > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network S
Re: Oracle on a SAN.... Good, Bad or Proceed with caution?
I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. >>> [EMAIL PROTECTED] 03/07/03 10:55AM >>> Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: >Amen! For several years we heard from EMC reps, don't worry about it, >don't worry about it, then recently we we're given a white paper from EMC >on striping for Oracle. > > > >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> >SAN is fine as long as you keep track of what's mapping to what physical >disks. I for one don't believe the SAN vendors that say their caching takes >care of performance for you and you don't need to worry about where data is >stored physically. Place datafiles the same way you would for local storage >and you will do well - striped, with data, indexes, temp, and rollback >physically separated. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, March 06, 2003 4:39 PM > > > > Hello, > > > > We are currently spec'ing out hardware for our new ERP system. It is > > either going to be Peoplesoft or Oracle. We are also debating on using a > > SAN rather than attached storage. I'm just looking for any > > positives/negatives/rules of thumb I should be aware of when running >Oracle > > on a SAN architecture provided that management goes that way. The SAN box > > we are looking at right now is the EVA3000 from HP (although this isn't a > > definite) not sure if this matters. > > > > TIA, > > -Scott Stefick > > > > ** > > Scott Stefick > > UNIX Systems Administrator > > Oracle Certified Professional DBA > > Wm. Rainey Harper College > > 847.925.6130 > > ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Scott Stefick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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.net >-- >Author: Chuck Hamilton > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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.net >-- >Author: Darrell Landrum > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com S
Re: Oracle on a SAN.... Good, Bad or Proceed with caution?
Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle. >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> SAN is fine as long as you keep track of what's mapping to what physical disks. I for one don't believe the SAN vendors that say their caching takes care of performance for you and you don't need to worry about where data is stored physically. Place datafiles the same way you would for local storage and you will do well - striped, with data, indexes, temp, and rollback physically separated. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 4:39 PM > Hello, > > We are currently spec'ing out hardware for our new ERP system. It is > either going to be Peoplesoft or Oracle. We are also debating on using a > SAN rather than attached storage. I'm just looking for any > positives/negatives/rules of thumb I should be aware of when running Oracle > on a SAN architecture provided that management goes that way. The SAN box > we are looking at right now is the EVA3000 from HP (although this isn't a > definite) not sure if this matters. > > TIA, > -Scott Stefick > > ** > Scott Stefick > UNIX Systems Administrator > Oracle Certified Professional DBA > Wm. Rainey Harper College > 847.925.6130 > ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Scott Stefick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle on a SAN.... Good, Bad or Proceed with caution?
Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle. >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>> SAN is fine as long as you keep track of what's mapping to what physical disks. I for one don't believe the SAN vendors that say their caching takes care of performance for you and you don't need to worry about where data is stored physically. Place datafiles the same way you would for local storage and you will do well - striped, with data, indexes, temp, and rollback physically separated. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 4:39 PM > Hello, > > We are currently spec'ing out hardware for our new ERP system. It is > either going to be Peoplesoft or Oracle. We are also debating on using a > SAN rather than attached storage. I'm just looking for any > positives/negatives/rules of thumb I should be aware of when running Oracle > on a SAN architecture provided that management goes that way. The SAN box > we are looking at right now is the EVA3000 from HP (although this isn't a > definite) not sure if this matters. > > TIA, > -Scott Stefick > > ** > Scott Stefick > UNIX Systems Administrator > Oracle Certified Professional DBA > Wm. Rainey Harper College > 847.925.6130 > ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Scott Stefick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle on a SAN.... Good, Bad or Proceed with caution?
SAN is fine as long as you keep track of what's mapping to what physical disks. I for one don't believe the SAN vendors that say their caching takes care of performance for you and you don't need to worry about where data is stored physically. Place datafiles the same way you would for local storage and you will do well - striped, with data, indexes, temp, and rollback physically separated. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 4:39 PM > Hello, > > We are currently spec'ing out hardware for our new ERP system. It is > either going to be Peoplesoft or Oracle. We are also debating on using a > SAN rather than attached storage. I'm just looking for any > positives/negatives/rules of thumb I should be aware of when running Oracle > on a SAN architecture provided that management goes that way. The SAN box > we are looking at right now is the EVA3000 from HP (although this isn't a > definite) not sure if this matters. > > TIA, > -Scott Stefick > > ** > Scott Stefick > UNIX Systems Administrator > Oracle Certified Professional DBA > Wm. Rainey Harper College > 847.925.6130 > ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Scott Stefick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle on a SAN.... Good, Bad or Proceed with caution?
Perhaps you'll enjoy James Morle's Sane SAN paper on www.OakTable.net - if you haven't seen it already. Best regards, Mogens Scott Stefick wrote: Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking for any positives/negatives/rules of thumb I should be aware of when running Oracle on a SAN architecture provided that management goes that way. The SAN box we are looking at right now is the EVA3000 from HP (although this isn't a definite) not sure if this matters. TIA, -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle on a SAN.... Good, Bad or Proceed with caution?
Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking for any positives/negatives/rules of thumb I should be aware of when running Oracle on a SAN architecture provided that management goes that way. The SAN box we are looking at right now is the EVA3000 from HP (although this isn't a definite) not sure if this matters. TIA, -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).