RE: GATHER_STATS_JOB

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Fri, 14 Aug 2009 10:01:04 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF023CAAE5_at_EXCNYSM0A1AJ.nysemail.nyenet>



Gene,

It runs sequentially.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Friday, August 14, 2009 9:55 AM
To: oracle-l_at_freelists.org
Subject: GATHER_STATS_JOB

Hello:

We have a GATHER_STATS_JOB running daily at 3AM and analyzing tables with
stale stats. Does this job analyze these tables one after another or does it run analyze on multiuple tables concurrently?
Does anyone know?

thank you

Gene Gurevich

Please consider the environment before printing this email.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 14 2009 - 09:01:04 CDT

Original text of this message