Does SQL plan baseline works for SQL with similar text
Hello expert,
I have created a SQL plan baseline for a query with literal values instead of bind variable like following
SQL> variable pls number;
SQL> exec :pls := dbms_spm.load_plans_from_sqlset(sqlset_name => '17J1101UR926K_CISP', basic_filter => 'sql_text like ''select distinct billmessag1_.BILL_MSG_CD%''');
When I execute same query with bind variable it does not use plan baseline.I know plan with literal is better than plan with bind variable.Please help me how to force optimizer to use plan with literval values?
Regards
Dhritiman Deb