Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gABIdk826685 for ; Mon, 11 Nov 2002 12:39:46 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gABIdkX26680 for ; Mon, 11 Nov 2002 12:39:46 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA48280; Mon, 11 Nov 2002 08:20:38 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00500123; Mon, 11 Nov 2002 07:28:41 -0800 Message-ID: Date: Mon, 11 Nov 2002 07:28:41 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Babette Turner-Underwood" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Babette Turner-Underwood" Subject: RE: Oracle & SAN Experiences? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0059_01C288A4.04DC0F60" ------=_NextPart_000_0059_01C288A4.04DC0F60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit The SysA client site that I was supporting a while ago had big problems with their NAS. While doing Oracle backups to tape, the application would drop connections. In a SAN environment, there might also be similar problems. -----Original Message----- Sent: Friday, November 08, 2002 9:59 AM To: Multiple recipients of list ORACLE-L The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and I’d like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB – 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (it’s possible to use smaller disks in the SAN) -Prove it! After reading the “Sane SAN” article and a case study about Volvo implementing a SAN, I believe it’s possible to have a great Oracle/SAN implementation if it’s setup correctly and tuned. Other resources that you can Google are “Using SVA SnapShot with Oracle”, “Performance Benchmark LSI Logic E4600 (STK D178)”, “SAN Storage for Open Systems Environments”, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA ------=_NextPart_000_0059_01C288A4.04DC0F60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The Sys
A=20 client site that I was supporting a while ago had big problems with = their=20 NAS.
While=20 doing Oracle backups to tape, the application would drop connections.=20
In a=20 SAN environment, there might also be similar = problems.
 
-----Original = Message-----
From:=20 root@fatcity.com [mailto:root@fatcity.com]On Behalf Of David=20 Wagoner
Sent: Friday, November 08, 2002 9:59 AM
To: = Multiple=20 recipients of list ORACLE-L
Subject: Oracle & SAN=20 Experiences?

The=20 Sys. Admin. team wants to consolidate storage (and probably get a new = toy too)=20 on all of our servers, so they are evaluating a SAN (LSI  Logic E4600).  The DBA team is doing some = research to=20 determine the pros and cons of doing this, and I=92d like to hear any = of your=20 experiences (good and bad) using SAN with=20 Oracle.

 

My=20 understanding is that all of our database servers would remain intact, = but the=20 attached disk storage would move into the SAN.  So, we still have the = Production,=20 Test, and App. servers with their processors and memory, Oracle homes, = etc.  The SAN will hold = database=20 files from Production, Test, Apps., staging, ODS,data warehouse,=20 etc.

 

Their=20 arguments:

-the=20 SAN is very scalable (500 GB =96 40 = TB)

-easy=20 to manage disks in one central = location

-fancy=20 statistics collection on all SAN = disks

-much=20 higher throughput on the fiber SAN connections than with locally = attached disk=20 arrays

-capable=20 of using mixed RAID levels (0, 1, 1+0, 5,=20 etc.)

-can=20 partition sets of disks in the SAN for specific server=20 access

-Snapshot=20 backup capability is very fast in the SAN (much faster than = traditional Oracle=20 backups)

 

DBA=20 arguments:

-How=20 will this affect database = performance?

-What=20 are the drawbacks, if any, with the pre-fetch of data performed by the = SAN=20 (i.e., SAN cache)

-How=20 tunable is the SAN

-Fast,=20 small disks are better for performance and less wasted space than the = typical=20 huge disks in a SAN (it=92s possible to use smaller disks in the=20 SAN)

-Prove=20 it!

 

 

After=20 reading the =93Sane SAN=94 article and a case study about Volvo = implementing a=20 SAN, I believe it=92s possible to have a great Oracle/SAN = implementation if it=92s=20 setup correctly and tuned.  = Other=20 resources that you can Google are =93Using SVA SnapShot with = Oracle=94,=20 =93Performance Benchmark LSI Logic E4600 (STK D178)=94, =93SAN Storage = for Open=20 Systems Environments=94, and of course check the=20 OraFaq.

 

Thanks=20 for sharing,

 

David=20 Wagoner

Oracle=20 DBA

 

 

 

 

------=_NextPart_000_0059_01C288A4.04DC0F60-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: babette@rogers.com 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: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).