Re: Select statement runs slow until flush of shared pool

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 27 Nov 2012 22:30:11 +0100
Message-ID: <50B530E3.6020208_at_gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 27 2012 - 22:30:11 CET

Original text of this message