Re: job fails

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 Feb 2014 21:30:35 -0700

On 20/02/2014 1:33 PM, Zelli, Brian wrote:

I'm running a dbms_stats.gather_schema_stats job thru a unix job and it runs for a while then fails with a

ORA-01013: user requested cancel of current operation

I didn't cancel the job so why is this stopping?


Do you have any associated profile or have you set up resource manager? This can also happen as a result of timeouts.

Alternately, is this a multi-step routine (once logged into Oracle) where one step is failing? If so, can you determine which step?

/Hans

Other related posts: