Re: Select statement runs slow until flush of shared pool

From: Radoulov, Dimitre <>
Date: Tue, 27 Nov 2012 22:30:11 +0100
Message-ID: <>

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.


Received on Tue Nov 27 2012 - 22:30:11 CET

Original text of this message