SQL Performance (MOSC)

MOSC Banner

Does SQL plan baseline works for SQL with similar text

edited Mar 17, 2017 4:33PM in SQL Performance (MOSC) 8 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center