Re: Difference in Execution Plan - Same Environment, Same SQL
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 2 May 2013 00:24:45 +0400
Message-ID: <CAOVevU5zc+gvQ9Eo1U2SLrNVDwfown2Hbrq6KXU-XjXmB1RJWg_at_mail.gmail.com>
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
Date: Thu, 2 May 2013 00:24:45 +0400
Message-ID: <CAOVevU5zc+gvQ9Eo1U2SLrNVDwfown2Hbrq6KXU-XjXmB1RJWg_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 01 2013 - 22:24:45 CEST