Re: Difference in Execution Plan - Same Environment, Same SQL

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: ross.lafferty@xxxxxxxxx
  • Date: Thu, 2 May 2013 00:24:45 +0400

What you see in note section of DBMS_xplan output?
I think it was cardinality feedback result. In that case try to disable it
with OPT_param('_optimizer_use_feedback', 'false')
If note section is empty, look at reason in v$sql_shared_cursor

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2013