Re: Implement Parallel Processing on DB Warehouse
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Feb 2004 10:45:11 -0500
Steve Adam's site says
"In a well managed shared pool, flushing should not be needed."
So is your shared pool too big or are people not using bind variables? So
all your users take a hit in the morning as they hard parse all the new sql
statements. But maybe you pin everything.
I agree flushing the shared pool is a very poor bandade for shared pool
problems.
Mike
ganstadba@xxxxxxxxxxx
----- Original Message -----
From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, February 11, 2004 10:15 AM
Subject: RE: Implement Parallel Processing on DB Warehouse
> Based on what? I have a job to flush our ERP daily partially in part by
> advice found on Steve Adams' site http://www.ixora.com.au As our nightly
> jobs will have aged out most every OLTP statement from the shared pool, I
> fail to see how a timely daily flush of the shared pool is harmful to our
> instance, which BTW is 8.1.7.4.0 on HP/UX 11.0 (9iR2 migrate in progress).
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
>
> -----Original Message-----
> From: Mladen Gogala [mailto:mladen@xxxxxxxxxxxxxxx]
> Sent: Tuesday, February 10, 2004 3:51 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Implement Parallel Processing on DB Warehouse
>
>
> On 02/10/2004 04:17:39 PM, "Freeman, Donald" wrote:
> > SET timing ON
> >
> > ALTER SYSTEM FLUSH SHARED_POOL;
>
> Flushing is harmful.
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
----------------------------------------------------------------
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:
