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: Implement Parallel Processing on DB Warehouse

RE: Implement Parallel Processing on DB Warehouse

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Sat, 14 Feb 2004 18:24:36 -0800 (PST)
Message-ID: <20040215022436.8350.qmail@web20419.mail.yahoo.com>

Rich,

you have little idea as to how bad things can get with regard to high use of non-reusable code. you might be getting by okay for now, but another business unit gets added, or another app module gets enabled, and the next thing you know, you're throwing 4031s.

be afraid. be very afraid.
do not count on cursor_sharing=FORCE to get you by. I would equate flushing the shared pool on a regular basis with "the boat is sinking, and the bailing pump motor is fried". time to don the lifejacket.

note: this has nothing to do with data warehousing.

Pd



Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.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 Sat Feb 14 2004 - 20:24:36 CST

Original text of this message

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