SQL Profile for parallel query

Hi all,

I need help for the following situation.

Query sql_id 84fam09g64jqm

AVG_EXEC_TIME is 7,1 or 9,3 seconds.

Inst 1 84fam09g64jqm       0 4185987665        875 6,258.37                7.15

Inst 2 84fam09g64jqm       0 4185987665        93     869.91               9.35

The query run about 10 hours while the amount of Data is very large.

During the long runtime the the SQL Tuning advisor find a recommendation for a SQL Profile

Recommendation (estimated benefit: 99.98%)

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

  - Consider accepting the recommended SQL profile to use parallel execution

    for this statement.

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

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

            DBMS_SQLTUNE.PX_PROFILE);

  Executing this query parallel with DOP 4 will improve its response time