RE: Do missing binds prevent creation of baseline?
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: "rjoralist2@xxxxxxxxxxxxxxxxxxxxx" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Apr 2013 19:57:31 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
