SymptomsOn : 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.
ORA-01013: user requested cancel of current operation
Bug 6033690, which is listed as a duplicate of Unpublished Bug 8281906
Run the DBMS_STATS.GATHER_DICTIONARY_STATS job.
Connect to the database instance as user sys in sqlplus.
Execute at the sql prompt:
Once completed run the Job AUTO_SPACE_ADVISOR_JOB.
The job will get the status SUCCEEDED and will not run for a long time.