SQL_Text on SQL Profile [message #677869] |
Thu, 17 October 2019 08:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
wtolentino
Messages: 398 Registered: March 2005
|
Senior Member |
|
|
our app developer group has this query that they run that is the same as the query text on the dba_sql_profiles view. however, it appears to be that the SQL profile is not being used by the optimizer. when i looked further the query that they run is different from the query text on the dba_sql_profiles. the only difference is the hints "/*+ INDEX ... */". the query text on the dba_sql_profiles does not have hints while the query that they are running has a hints.
should the query be exactly the same as the query text on the dba_sql_profile for that to be recognize by the optimizer (text sensitivity such as upper and lower case, white space etc.)?
thanks,
warren
[Updated on: Thu, 17 October 2019 08:54] Report message to a moderator
|
|
|
|
Re: SQL_Text on SQL Profile [message #682944 is a reply to message #677869] |
Sun, 22 November 2020 12:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/58ea53b2eb012dca61431eb2407e3263?s=64&d=mm&r=g) |
LNossov
Messages: 318 Registered: July 2011 Location: Germany
|
Senior Member |
|
|
No. The signature has to be the same. If you created your profile with force_match => true then the force matching signature has to be the same. If you created your profile with force_match => false (it is the default) then the exact matching signature has to be the same.
In your case the hint makes the signatures different.
|
|
|