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>

"Jesse, Rich" <Rich.Jesse_at_quadtechworld.com> wrote:
> "It depends"
>
> After reading Cary'n'Jeff's book, I stand by the
> original decision to flush
> daily. To change all in-house programs to use bind
> variables would be very
> costly without adding any discernable value to our
> customers (users). And
> to get a vendor to do the same would require some
> photos to blackmail them
> with. I would *love* to be able to go back and help
> our folks understand
> why bind variables are necessary from the start, but
> it ain't gonna happen.
>
> Now, back to migrating databases...
>
> Rich
>
> Rich Jesse System/Database
> Administrator
> rich.jesse_at_quadtechworld.com QuadTech, Sussex,
> WI USA

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.

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