RE: Implement Parallel Processing on DB Warehouse

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Feb 2004 10:05:52 -0600

"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
-----------------------------------------------------------------

Other related posts: