Re: GATHER_STATS_JOB behavior changed between 10g and 11g
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 28 Aug 2009 09:48:37 -0700 (PDT)
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
