RE: Execution plan changing

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Fri, 14 Sep 2012 13:47:29 +0000
Message-ID: <DUB115-W441A6804D08A2CA54C6FC5A1900_at_phx.gbl>

Can this be attributed to execution plan changes?

Get the execution plans via DBMS_XPLAN.DISPLAY_CURSOR including predicates and notes section, note the plan differences. See also V$SQL_SHARED_CURSOR for reasons for multiple child cursors.

Execution plan degradations on subsequent executions can often be attributed to cardinality feedback but that depends on version (something you've not mentioned). Cardinality_feedback is flagged in V$SQL_SHARED_CURSOR (inconsistently?) and in V$SQL_PLAN.OTHER_XML                                                

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

Received on Fri Sep 14 2012 - 08:47:29 CDT