Re: Really strange performance issue

  • From: Paul Drake <bdbafh@xxxxxxxxx>
  • To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • Date: Thu, 30 Oct 2014 13:59:27 -0400

Less than mature features being enabled by default in new releases requires
database administrators.
On Oct 30, 2014 10:40 AM, "Andrew Kerber" <andrew.kerber@xxxxxxxxx> wrote:

> 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?
>
> Sent from my iPad--
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: