I'm using Cloud Control 12c, i found that automatic SQL Tuning Result can have many rows of recommendations.
Can I export all of them ? I got too many rows for create indexes, but i can't find the export function from CC12c !
Any other commands or view I can find this recommendations ?
very thanks, seems i can get the action inside dba_advisor_actions.
I can get most I want inside dba_advisor_recommendations and dba_advisor_actions.
But, do you know how to get the SQL ID or the SQL Text?
Not sure. I always use the report to get all the information. The report includes the SQL ID.
https://oracle-base.com/articles/10g ... ng_advisor
I guess you could trace the report and find out where it is getting it from.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests