8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Automatic SQL Tuning in Oracle Database 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..

Viacheslav Andzhich said...

There is one interesting observation for 12.2 (probably valid for earlier versions also):
Since empno is a PK of EMP table, the predicate
WHERE NVL(empno, '0') = :empno
Gets processed by optimizer as:
access("E"."EMPNO"=:EMPNO)
I.e. it's certain about absence of NULLs, and just omits the NVL function. Thus, you won't get second recommendation in the Advisor findings.

Viacheslav Andzhich said...

Won't work with COALESCE() though :)

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.