SQL Performance (MOSC)

MOSC Banner

Attach Single Sql Profile for different sql_texts

edited Dec 19, 2014 10:04AM in SQL Performance (MOSC) 3 commentsAnswered

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.

Tagged:

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