Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Potentially better execution plan from Toad

- A -Sep 8 2008

Hi
I am using oracle 10gR1 and want to use a better execution plan from Toad(9.0.0.160) but not execcuted succesfully.
Help me

Error is received from Toad is
ORA-13605: The specified task or object string does not exist for the current user.
ORA-06512: at stringline string

A potentially better execution plan was found for this statement.

Recommendation (estimated benefit: 79.31%)

Consider accepting the recommended SQL profile.

execute :profile_name := dbms_sqltune.accept_sql_profile(task_name =>
'DBA6839699.5487580324')

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2008

Added on Sep 8 2008

#general-database-discussions

0 comments

230 views