Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here
I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to fix plans for queries and believe me its very easy and quick way of fixing problems in production database. I have not yet used SPM to baseline everything and only using it on need basis for fixing sql with bad plans. I have been reading about Automatic SQL tuning advisor in 11g and would be trying to use it and see the recommendations proposed by it (will keep accept_sql_profiles to false 🙂 )
Recent Comments