RE: Do missing binds prevent creation of baseline?
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Mon, 15 Apr 2013 19:57:31 +0000
Message-ID: <DUB115-W76B88F951493F90B8BD96A1CC0_at_phx.gbl>
There are many ways to skin this quick fix cat. 1. If the plan is in AWR then transfer into a baseline using DBMS_SQLTUNE.LOAD_SQLSET with DBMS_SQLTUNE.SELECT_WORKLOAD_REPOSITORY then sqlset to baseline using DBMS_SPM.LOAD_PLANS_FROM_SQLSET
Date: Mon, 15 Apr 2013 19:57:31 +0000
Message-ID: <DUB115-W76B88F951493F90B8BD96A1CC0_at_phx.gbl>
There are many ways to skin this quick fix cat. 1. If the plan is in AWR then transfer into a baseline using DBMS_SQLTUNE.LOAD_SQLSET with DBMS_SQLTUNE.SELECT_WORKLOAD_REPOSITORY then sqlset to baseline using DBMS_SPM.LOAD_PLANS_FROM_SQLSET
2. Run the SQL manually with a hint and then transfer the plan into a baseline for the original SQL using DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (Can be done in a non-prod environment and exported)
3. Use a SQL Patch using SYS.DBMS_SQLDIAG_INTERNAL.I_CREATE_PATCH.
4. Use a SQL Profile to apply outline style hints via COE_XFR_SQL_PROFILE.SQL - See Oracle Support doc id 215187.1
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 15 2013 - 21:57:31 CEST