Database Tuning (MOSC)

MOSC Banner

when to use force_matching with sql profiles?

edited Apr 29, 2023 12:54AM in Database Tuning (MOSC) 5 commentsAnswered ✓


hi


when to use force_matching with sql profiles?



Our queries only use bind variables. We don't use literals/values when writing the query. I assume in this case force_matching is not needed?




I took a look at this document

"How To Use SQL Profiles for Queries Using Different Literals Using the Force_Match Parameter of DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (Doc ID 1253696.1)"


It's a good document but it was really clear to me. I also checked a few blogs but I couldn't really get definitive answer.


Thank you

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