8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Automatic SQL Tuning in Oracle Database 10g

Automatic SQL Tuning in Oracle Database 10g - This article the discusses the new features which automate the tuning of SQL statements in Oracle 10g.

thanks said...

thank you

DBA said...

SELECT DBMS_SQLTUNE.report_tuning_task('my_tuning_task') as recommendation from dual;


1 row selected.

This doesn't show any recommendations? What could be the problem?

Tim... said...


Either you've done something wrong, or there are no recommendations.



PS. Questions on the forum, not in the comments!

DBA said...

Good and very handy doc...short and sweet ...

Vengat said...

Another precise and easy article from Tim .Thanks

Hashmi said...

Dear Tim,

What happens after accepting the sql profile?

Does the optimizer chooses the recommeded execution plan once the query runs again?

Tim... said...


The optimizer looks for profiles before doing a parse of a new statement.



Yasir Hashmi said...

You are a Genie Sir!!

Jr DBA said...

concise and beautiful.. just what i was looking for after the ADDM suggestion..

thank you..

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!