Re: GATHER_STATS_JOB behavior changed between 10g and 11g

From: Yong Huang <>
Date: Fri, 28 Aug 2009 09:48:37 -0700 (PDT)
Message-ID: <>

> 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       

Received on Fri Aug 28 2009 - 11:48:37 CDT

Original text of this message