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
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