Re: Really strange performance issue
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Thu, 30 Oct 2014 09:54:02 -0500 (CDT)
Message-ID: <04643c56ac4f0c6256296f2d416cba38.squirrel_at_society.servebeer.com>
Andrew posts:
Date: Thu, 30 Oct 2014 09:54:02 -0500 (CDT)
Message-ID: <04643c56ac4f0c6256296f2d416cba38.squirrel_at_society.servebeer.com>
Andrew posts:
> 11.2.0.3 EE on aix
>
> I have a query that runs in .01 seconds when not in shared pool. If it is
> present in the shared pool it takes over 15 minutes to run. In other words,
> the first time I run it, it runs immediately. The second time, it takes 15
> minutes. If I flush the shared pool it again runs in .01 sec. This looks
> like a bug to me, but I can't find it. Anyone have any ideas on this?
What's it waiting on during those 15 minutes? Are the execution plans different between the two runs?
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 30 2014 - 15:54:02 CET