Re: GATHER_STATS_JOB behavior changed between 10g and 11g
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 28 Aug 2009 09:48:37 -0700 (PDT)
Message-ID: <204678.64707.qm_at_web80605.mail.mud.yahoo.com>
> According to Bug 7140600, the error ORA-54 is due to contention on
> JI lock. How about you disable the auto stats job and schedule that
> through OS, as a UNIX cron job or Windows scheduled task?
Date: Fri, 28 Aug 2009 09:48:37 -0700 (PDT)
Message-ID: <204678.64707.qm_at_web80605.mail.mud.yahoo.com>
> According to Bug 7140600, the error ORA-54 is due to contention on
> JI lock. How about you disable the auto stats job and schedule that
> through OS, as a UNIX cron job or Windows scheduled task?
Ignore that. There're four lock types named like J_. All but JI are about jobs. JI is about "Materialized View" according to v$lock_type. If it were related to a job, my suggestion would make sense. Sorry for my mistake.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 28 2009 - 11:48:37 CDT