Re:
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Thu, 18 Apr 2013 11:20:21 +0100
Message-ID: <DUB402-EAS300CB4F58C2258ACB2D5335A1CF0_at_phx.gbl>
Before reverting to best cost plan, there are two attempts to reproduce the baselined plan id. SPM trace is pretty clear about this.
Date: Thu, 18 Apr 2013 11:20:21 +0100
Message-ID: <DUB402-EAS300CB4F58C2258ACB2D5335A1CF0_at_phx.gbl>
Before reverting to best cost plan, there are two attempts to reproduce the baselined plan id. SPM trace is pretty clear about this.
SPM lists "round 1" as plan outline + session OFE (optimizer features enable).
If the plan still doesn't match then "round 2" is hinted OFE only.
Cheers,
Dominic
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 18 2013 - 12:20:21 CEST