This uses the coe_xfr_sql_profile.sql which is part of sqlt download from Oracle, but also available from other sites such as : once downloaded from SQLT or above we can use it to pin a SQL query to a good plan as below: This creates a file with the SQLID and plan hash in the name, … Continue reading SQLPlan Management using Profiles