SQL Profile
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.