SQLTXPLAIN plan_hash_value
Hi all,We have the following test case:
1) cursor_sharing=force in database side
2) The statement is not use bind variable (So Oracle do it for us)
3) In this context, the SQL executed with “alter session set cursor_sharing=exact” works very fine
So i decided to create sql profile with sqlt (coe_xfr_sql_profile.sql script) (with force_match=TRUE) to fix the plan for all litterals values.
Assume the good plan plan_hash_value and sql_id (with cursor_sharing=exact) equals:
XXXXXXXX/abcd
1) cursor_sharing=force in database side
2) The statement is not use bind variable (So Oracle do it for us)
3) In this context, the SQL executed with “alter session set cursor_sharing=exact” works very fine
So i decided to create sql profile with sqlt (coe_xfr_sql_profile.sql script) (with force_match=TRUE) to fix the plan for all litterals values.
Assume the good plan plan_hash_value and sql_id (with cursor_sharing=exact) equals:
XXXXXXXX/abcd
After sql profile created, i execute the original SQLs without setting cursor_sharing
0