RE: Query runs fine on InstanceA but slow on InstanceB...

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "cary.millsap@xxxxxxxxxxxx" <cary.millsap@xxxxxxxxxxxx>, "dmann99@xxxxxxxxx" <dmann99@xxxxxxxxx>, "kellyn.potvin@xxxxxxxxx" <kellyn.potvin@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Jan 2012 23:30:17 +0000

Great suggestions from Kellyn and Cary, but from the OP, it sounds like he's 
already isolated the problem to a specific query, and already identified that 
it's getting two different explain plans and what he's really trying to figure 
out is why the two different plans are being chosen.

David, can you please confirm if my understanding is correct so we can focus 
the discussion more?



Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: