Re: Select statement runs slow until flush of shared pool

From: Radoulov, Dimitre <>
Date: Tue, 27 Nov 2012 19:18:58 +0100
Message-ID: <>

Hi Finn,

On 27/11/2012 18:34, Jorgensen, Finn wrote:
> List:
> EE on Solaris. No RAC.
> I have a client who run a report which consist of just a select statement. Nothing really special except there's a couple of stored function calls in the select.
> From time to time while running this report it gets hung up and takes hours to complete. When that happens somebody on the DBA team realized that flushing the shared pool fixes the problem and the report end almost immediately after the flushing.

We had a similar issue with clients that were using old versions of the jdbc thin driver that didn't support bind variable peaking, so you may check for different execution plans for the same statement. Note 273635.1 - Oracle JDBC Thin Driver Generates Different Execution Plan - describes the issue.


Received on Tue Nov 27 2012 - 19:18:58 CET

Original text of this message