Re: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC

  • From: Don Seiler <don@xxxxxxxxx>
  • To: gabriel.aragon@xxxxxx
  • Date: Wed, 23 Jun 2010 14:32:17 -0500

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: