Re: Select statement runs slow until flush of shared pool

From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
To: Finn.Jorgensen@xxxxxxxxxxxxxxxxx
Date: Tue, 27 Nov 2012 22:30:11 +0100

On 27/11/2012 22:25, Radoulov, Dimitre wrote:
> On 27/11/2012 20:48, Jorgensen, Finn wrote:
>> The execution plan doesn't change once the statement is running. 
>> That's why I went down the path of latches etc.
>
> As I already said, we had a very similar issue, flushing the shared 
> pool seemed to affect the plan immediately.
> I don't know if the plan of the SQL invoked by the function is 
> guaranteed to remain the same during execution.

Just to clarify: by "the function" I mean the "function calls in the 
select" list.


Regards
Dimitre
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- RE: Select statement runs slow until flush of shared pool
  - From: Jorgensen, Finn

References:
- Select statement runs slow until flush of shared pool
  - From: Jorgensen, Finn
- Re: Select statement runs slow until flush of shared pool
  - From: Tanel Poder
- RE: Select statement runs slow until flush of shared pool
  - From: Jorgensen, Finn
- Re: Select statement runs slow until flush of shared pool
  - From: Radoulov, Dimitre

Re: Select statement runs slow until flush of shared pool

Other related posts: