Export Recommendations from Automatic SQL Tuning Result

[peterx]

hi Tim,

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 ?

thanks.

[peterx]

hi Tim,

very thanks, seems i can get the action inside dba_advisor_actions.

thanks!

[peterx]

hi Tim,

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?

thanks.

[Tim...]

Hi.

Not sure. I always use the report to get all the information. The report includes the SQL ID.

http://www.oracle-base.com/articles/10g ... ng_advisor

I guess you could trace the report and find out where it is getting it from.

Cheers

Tim...