Attach Single Sql Profile for different sql_texts
Hi All,
In Oracle 11g, is there any way where we can attach a sql_profile / outline/ baseline to some query which have different sql_ids.
For example,
I have a sql_id 46dfwf34dvgsv and I have applied sql_profile to the query which the sql text as follows,
SELECT COUNT(*) AS VAL
FROM X11
WHERE a = :1 AND b = :2 AND c >= SYSDATE-(:3 /86400) AND d = :4 AND e = :5 AND f = :6;
Now my application team is running with different selection criteria like
SELECT COUNT(*) AS VAL
FROM X11
WHERE a = :1 AND b = :2 AND c >= SYSDATE-(:3 /86400) AND k = :4 AND f = :5;
As the sql_id changes, the sql profile which I created manually will not work.