Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using NetApp Filers for a DWH

RE: Using NetApp Filers for a DWH

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 5 Aug 2004 10:24:29 -0400
Message-ID: <D9530056A14A6244BCC838513C9F6FA137D9C3@EXCHSERV1.Limited.brands.com>


We use a lot of the Net filer/ here Dennis. We bumped to fibre cards and many various option to speed things up. We get awesome performance...BUT... And a big butt. We have had the system slow down vastly when certain settings were not set correctly like async stuff. We had a router set wrongly so that our disaster recovery site lines were slow and cause some special file to fill up and slow the system down. We also have the continous access disaster recovery software...with certain settings not set (async something) also create big impact to the entire system. Let me tell you.. Real fun tuning when you have SQUAT for monitoring tools. This net filer stuff works well when all the kinks are worked out..and we are running it with quite a load. Network connection issues were cause of I would say 3-4 major issues..(during setup of 2 year project).

Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
Sent: Thursday, August 05, 2004 10:06 AM To: 'oracle-l_at_freelists.org'
Subject: RE: Using NetApp Filers for a DWH

One issue I haven't heard anyone mention is the network link. My understanding is that the link should be dedicated (separate network card / ip address), and as fast as possible. My experience is meager and several years old, but my impression is that sometimes a slow network connection can cause performance problems with these devices.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Binley Lim
Sent: Thursday, August 05, 2004 8:41 AM
To: oracle-l_at_freelists.org
Subject: Re: Using NetApp Filers for a DWH

I agree that it's not a RAID-4 problem (or even WAFL), because the OP said this particular problem did _not_ reproduce on 9.2.0.4.

Cannot be a 10g-specific problem either, or you would know...

So it could be an Oracle/NetApp combination (and assuming NFS) problem? ... or the OP missed something?

>
> That's not it. The RAID-4 has nothing to do with this behavior.
> The=20 behavior described is symptomatic of a WAFL filesystem with an=20
> oversubscribed cache. Since WAFL will never overwrite an existing=20
> block, but simply append writes to the next available slot in the
> free=20=
>
> block list, the tablespace described will effectively be located=20
> half-and-half on two different filesystem regions.
>
> If there was enough (read: a lot) of cache in the filer, this
> problem=20 would be mitigated, since all of the recently modified
> blocks would be=20=
>
> in cache, but overall this is definitely the worst-case situation for
a=20=
>
> Netapp.
>
> Thanks,
> Matt
>
>
> --
> Matthew Zito
> GridApp Systems
> Email: mzito_at_gridapp.com
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
>
>
> On Aug 4, 2004, at 7:54 PM, Mogens N=F8rgaard wrote:
>
> > I like the NetApp guys, etc. But it is really RAID-4 (no kidding),
> > so perhaps that might explain one or two things? Just guessing...
> >
> > Mogens




Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Aug 05 2004 - 09:25:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US