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.
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-lReceived on Tue Nov 27 2012 - 22:30:11 CET