"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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA -----Original Message----- From: Michael McMullen [mailto:ganstadba@xxxxxxxxxxx] Sent: Wednesday, February 11, 2004 9:45 AM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------