This forum is currently locked. You can't register or post questions at this time. (read more)

Export Recommendations from Automatic SQL Tuning Result

All posts relating to Oracle database administration.

Moderator: Tim...

peterx
Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Export Recommendations from Automatic SQL Tuning Result

Postby peterx » Thu Jan 03, 2013 9:30 am

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
Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Re: Export Recommendations from Automatic SQL Tuning Result

Postby peterx » Thu Jan 03, 2013 11:06 am

hi Tim,

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

thanks!

peterx
Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Re: Export Recommendations from Automatic SQL Tuning Result

Postby peterx » Thu Jan 03, 2013 11:47 am

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Export Recommendations from Automatic SQL Tuning Result

Postby Tim... » Thu Jan 03, 2013 3:00 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 5 guests

cron