Database Tuning (MOSC)

MOSC Banner

SQL Plan Baseline using sql_text with wildcards - possible?

edited Apr 30, 2020 5:51AM in Database Tuning (MOSC) 3 commentsAnswered ✓

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 

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