Re: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: don@xxxxxxxxx, gabriel.aragon@xxxxxx
- Date: Wed, 23 Jun 2010 13:47:16 -0700 (PDT)
A google.search throws up a few hits, but I'm not clear on the original source.
It's complete bunk, of course - and if true should be treated as a bug.
RF
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
________________________________
From: Don Seiler <don@xxxxxxxxx>
To: gabriel.aragon@xxxxxx
Cc: oracle list <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, June 23, 2010 1:32:17 PM
Subject: Re: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC
What site did you read that?
Aside from a bug in 10.2.0.2 when combined with auto SGA-management, I
haven't had any problems with the GATHER_STATS_JOB nightly/weekend
job.
Don.
On Wed, Jun 23, 2010 at 2:03 PM, Aragon, Gabriel (GE, Corporate,
consultant) <gabriel.aragon@xxxxxx> wrote:
> Hi Just found in a site:
>
> "DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC collection of statistical
> information. The process first detects missing and old-fashioned statistical
> information objects. Then determine the priority, and then start statistics.
> The automatic analysis may lead to extremely serious latch competition,
> which could lead to a database Hang or Crash."
>
> So, should I remove this and implement my own stats collect job? Can someone
> pls share some light on this?
>
> TIA
> Gabriel
>
>
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l
Other related posts:
