OEM - SQL Tuning - Are sql tuning optimizations shared across users in database?
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?