Home » RDBMS Server » Performance Tuning » SQL_Text on SQL Profile (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0)
SQL_Text on SQL Profile [message #677869] Thu, 17 October 2019 08:40 Go to next message
wtolentino
Messages: 282
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 #677870 is a reply to message #677869] Thu, 17 October 2019 09:01 Go to previous message
Michel Cadot
Messages: 66687
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes.

Previous Topic: queue management system
Next Topic: Disk file operations i/o
Goto Forum:
  


Current Time: Sun Nov 17 01:00:46 CST 2019