Re: Really strange performance issue
- From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 30 Oct 2014 09:54:02 -0500 (CDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
