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