Export Recommendations from Automatic SQL Tuning Result

All posts relating to Oracle database administration.

Moderator: Tim...

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

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


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest