Re: Really strange performance issue

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 30 Oct 2014 10:56:24 -0600

Andrew,

Please create a SQL*Plus script of your test case, enable extended level-12 SQL tracing, stop guessing, and work with facts.

Suggested commands to enable extended level12 tracing within the script...

   alter session set max_dump_file_size = unlimited;
   alter session set tracefile_identifier = andrew;
   alter session set statistics_level = all;
   alter session set events '10046 trace name context forever, level 12';


Hope this helps!

Thanks!

-Tim


On 10/30/14 8:38, Andrew Kerber 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: