Database Tuning (MOSC)

MOSC Banner

With regards to sql profile: will it be accepted for identical statements with different schema?

in Database Tuning (MOSC) 5 commentsAnswered ✓

hi,

With regards to sql profile: will it be accepted for identical statements with different schema? 


Assume that ACCEPT_SEQUEL_PROFILE is set to TRUE.



From example, let says the sql optimizer accepted sql profile "SYS_SQLPROF_016870b70a9b0000" for below query


select * from A_OWNER.EMP, A_OWNER.DEP WHERE <COMPLEX_CONDITION>;


will the optimizer also use the sql profile for the query below? Schema names are different.  


select * from B_OWNER.EMP, B_OWNER.DEPT WHERE <COMPLEX_CONDITION>;


The queries are exactly the same except for schema owner A_OWNER vs. B_OWNER.



I believe the answer is "No" even if EMP and DEPT table were exactly same structure and exactly same data, the sqls are considered different.

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