Loading SQL Plans into SPM using AWR
Often you may need to load SQL Plans into SPM but isn’t possibile because query is out of cache. There is a simple procedure for loading SQL plans into SPM using AWR data. The first step, if not exists, is to create a SQL Tuning Set (STS). exec dbms_sqltune.create_sqlset(sqlset_name => ‘1ffbnq9wwkhtz_sqlset_test’, description => ‘query test’); Name and description are customizable. In sqlset_name I using even sql_id because in this way I can remember the query. Next step is to take initial and final snapshot id. I prefer generate AWR report to make sure that the query was running. Obviously...