Database Tuning (MOSC)

MOSC Banner

Discussions

Change existing SQL_PROFILE(s) to FORCE_MATCH true without recreating?

in Database Tuning (MOSC) 4 commentsAnswered ✓

Oracle Enterprise DB 19

Is there a way to change a SQL_PROFILE to FORCE_MATCH = true using something like DBMS_SQL_TUNE.ALTER_SQL_PROFILE vs having to recreate it? I have several SPA created profiles and would like to change them to FORCE_MATCH=true with a bulk operation.

thanks.

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.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center