Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

OEM - SQL Tuning - Are sql tuning optimizations shared across users in database?

edited Jan 22, 2019 1:55PM in Managing Databases using Enterprise Manager (MOSC) 2 commentsAnswered ✓

HI MOSC,

We frequently review our sql tuning result details and advice:

Advisor Central  >   SQL Tuning Summary:SYS.SYS_AUTO_SQL_TUNING_TASK  >  Automatic SQL Tuning Result Details: All Analyzed SQLs

On our 11g clinical application database, we see that some of our schemas share nearly the same canned report SQL but the SQL itself is slightly different in each schema.

But the recommendations too are sometimes exactly similar, ie "add an index to this table" (schemas are atomic, self contained and do not share objects with other schemas).

Question:  Are sql tuning optimizations shared across users in database even the sql and sql recommendations are listed for each unique schema?

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