SQL Performance (MOSC)

MOSC Banner

Tunning query and my database

edited Mar 27, 2014 12:00PM in SQL Performance (MOSC) 3 commentsAnswered

Hello Gurus,

    I would tune a query, I retrieved the query who is slow Then

1 - I created a task with this next option :

Tuning Task Name  : TASK_71402

Scope              : COMPREHENSIVE

Time Limit(seconds): 1800

Completion Status  : COMPLETED

Started at        : 03/19/2014 15:46:31

Completed at      : 03/19/2014 15:46:46

2 - after i executed this task

3 - I saw the advice then :

And i would know if my solution is only execute dbms_sqltune.accept_sql_profile or have i an other solution by create again my query ?  or an other solution ?

best regards

JP

  Recommendation (estimated benefit: 97.37%)

  ------------------------------------------

    Consider accepting the recommended SQL profile.

    execute :profile_name := dbms_sqltune.accept_sql_profile(task_name =>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center