RE: Implement Parallel Processing on DB Warehouse

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 11 Feb 2004 10:05:52 -0600
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E936C2@qtiexch2.qgraph.com>

"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

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

From: Michael McMullen [mailto:ganstadba_at_hotmail.com] Sent: Wednesday, February 11, 2004 9:45 AM To: oracle-l_at_freelists.org
Subject: Re: Implement Parallel Processing on DB Warehouse

[snip]

I agree flushing the shared pool is a very poor bandade for shared pool problems.

Mike

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 Wed Feb 11 2004 - 10:05:52 CST