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 12:11:47 -0400
Message-ID: <D9530056A14A6244BCC838513C9F6FA137D9C4@EXCHSERV1.Limited.brands.com>

No can't really, because after combing the system top to bottom... Finally the network and Admin guys are force to find something. I didn't have access to it. Some of our errors would have specifically to do with us pumping data offsite...and part of our network route was reducing..which caused the whole system to go down.

But.. On the oracle side..we did find some significant bugs in Oracle 9.2.0.4. One I can remember was truncates etc were taking a long time. Adding the patch to go to 9.2.0.5 solved several problems. The other one I remember was that 9i was giving plans that did not work well is some cases ....

Parameters.
query_rewrite_enabled = (set this on) Drastically helped memory requirements  _complex_view_merging FALSE (We inserted this ..and it did wonders.)

We had to delete statistics from temporary tables (which we had many )

My memory is fading on the changes..but hope that helps.

Brian

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
Sent: Thursday, August 05, 2004 11:16 AM To: oracle-l_at_freelists.org
Subject: RE: Using NetApp Filers for a DWH

I wonder if you documented [or made a "bullet-point" list of] the major issues ?
What were the settings that you had to change / reconfigure ?

At 10:24 PM Thursday, you wrote:
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

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital



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 - 11:07:34 CDT

Original text of this message

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