Job AUTO_SPACE_ADVISOR_JOB takes too long

The Job AUTO_SPACE_ADVISOR_JOB Takes Long Time And Result In Status STOPPED [ID 1069782.1]

Symptoms

On : 10.2.0.4 version, EM Job System (using the Agent - not DBMS Jobs)

When attempting to check the runtime for job AUTO_SPACE_ADVISOR_JOB
the following error occurs.

ERROR
-----------------------
ORA-01013: user requested cancel of current operation

Cause

Due to Bug 6033690, which is listed as a duplicate of Unpublished Bug 8281906

Solution

A valid workaround is to gather dictionary statistic prior to run the AUTO_SPACE_ADVISOR_JOB job.

Run the DBMS_STATS.GATHER_DICTIONARY_STATS job.

Connect to the database instance as user sys in sqlplus.
Execute at the sql prompt:

exec DBMS_STATS.GATHER_DICTIONARY_STATS

Once completed run the Job AUTO_SPACE_ADVISOR_JOB.

The job will get the status SUCCEEDED and will not run for a long time.