Comments
| 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;RECOMMENDATION -------------------------------------------------------------------------------- GENERAL INFORMATION SECTION ---------------------------------------------------- 1 row selected. This doesn't show any recommendations? What could be the problem? |
Tim... said... Hi.Either you've done something wrong, or there are no recommendations. Cheers Tim... 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... Hi.The optimizer looks for profiles before doing a parse of a new statement. Cheers Tim... |
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, that's what my forum is for!
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!