Sunday 30 November 2014

Force plan to use Oracle

Forces a query to run using the same plan it had used on a previous tuning attempt to improve the query's performance.
 
The coe_xfr_sql_profile.sql  script generates another script that, in turn, contains the commands to create a manual custom SQL Profile out of a known plan that resides in RAM (library cache) or from the AWR dba_hist_sqlplan table. 



sqlt-coe_xfr_sql_profilesql -Useful tool in sqlt



Refer below  source code link for this fix:


http://kerryosborne.oracle-guy.com/scripts/coe.sql


No comments:

Post a Comment