Re: job fails
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Thu, 20 Feb 2014 21:30:35 -0700
Message-ID: <5306D66B.8040200_at_gmail.com>
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.
Date: Thu, 20 Feb 2014 21:30:35 -0700
Message-ID: <5306D66B.8040200_at_gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 21 2014 - 05:30:35 CET