Database Tuning (MOSC)

MOSC Banner

How to get SYS_AUTO_SQL_TUNING_TASK to respect PUBLIC synonyms ?

edited Nov 8, 2019 11:46AM in Database Tuning (MOSC) 2 commentsAnswered ✓

12.2 Autonomous Health System - SQL Tuning

First, acknowledgement that public synonyms are evil and should be avoided.     We bought the app and unfortunately they came in the basket.

I've tried several usernames other than the value 'UNUSED' below, and in all cases analysis fails on candidate SQL that relies on public synonyms (some USERNAMEs fared better than others obviously ...)..

How to get SYS_AUTO_SQL_TUNING_TASK to respect PUBLIC synonyms ?    Awaiting my d-oh moment ... via your response ... alex

Here are my last settings:

SELECT parameter_name, parameter_value

FROM   dba_advisor_parameters

WHERE  task_name = 'SYS_AUTO_SQL_TUNING_TASK' order by 1,2;

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