Re: GATHER_STATS_JOB behavior changed between 10g and 11g
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 27 Aug 2009 14:03:22 -0700 (PDT)
Message-ID: <553566.44987.qm_at_web80608.mail.mud.yahoo.com>
> Reading MetaLink about this issue, I would say the answer is "no", a
> couple of bugs have been logged around this and the one specifically
> regarding the automatic job (5411956) is labelled "Not Feasible to
> fix, to Filer"!
Date: Thu, 27 Aug 2009 14:03:22 -0700 (PDT)
Message-ID: <553566.44987.qm_at_web80608.mail.mud.yahoo.com>
> Reading MetaLink about this issue, I would say the answer is "no", a
> couple of bugs have been logged around this and the one specifically
> regarding the automatic job (5411956) is labelled "Not Feasible to
> fix, to Filer"!
Chen and Pete,
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?
BTW, Bug 5411956 says the problem started in 10gR2. But Chen's problem did not exist in 10.2.0.2 and started in 11g. But Bug 8407017 clearly says "Reproduced ORA-54 on 10.2.0.2". So Chen might just be lucky in 10g.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 27 2009 - 16:03:22 CDT