SQL Performance (MOSC)

MOSC Banner

SQL Profile

edited Apr 28, 2017 5:03AM in SQL Performance (MOSC) 20 commentsAnswered

Dear All,

After run dbms_sqltune.create_tuning_task utility I got a recommendation  to create a SQL profile cause to  speed up very slow query;

Recommendation (estimated benefit: 84.84%)

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

  - Consider accepting the recommended SQL profile to use parallel execution

    for this statement.

    execute dbms_sqltune.accept_sql_profile(task_name => 'dbiInSite',

            task_owner => 'SYS', replace => TRUE, profile_type =>

            DBMS_SQLTUNE.PX_PROFILE);

I've created the recommended one by name "SYS_SQLPROF_015b668966960001" but after re run the same query I got a message as follows:

SQL Profile "SYS_SQLPROF_015b668966960001" exists for this statement and was ignored during the tuning process.

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