SQL Plan Baseline using sql_text with wildcards - possible?
Hi
Oracle 12.1.0.2.0
cursor_sharing=EXACT
Is it possible to create sql plan baseline with sql_text where I have wildcards in it..?
For example, let's say I have the following sql's in cursor cache, note that the select part differs, but rest of the query remains the same.
insert into tmp_otsing(type, id) select 'ctx_29', id from tab1 where contains(name, :bind_value) > 0;insert into tmp_otsing(tyyp, id) select 'ctx_27', id from tab1 where contains(name, :bind_value) > 0;insert into tmp_otsing(tyyp, id) select 'ctx_37', id from tab1 where contains(name, :bind_value) > 0;.... let's say there will be 5 more statements like this in the cursor cache in near future, where this