RE: GATHER_STATS_JOB

From: <genegurevich_at_discover.com>
Date: Fri, 14 Aug 2009 10:01:49 -0500
Message-ID: <OF5B25899C.BDF6BED0-ON86257612.00528A8B-86257612.0052945F_at_discover.com>



Thank you, Tom

thank you

Gene Gurevich

                                                                           
             "Mercadante,                                                  
             Thomas F (LABOR)"                                             
             <Thomas.Mercadant                                          To 
             e_at_labor.state.ny.         <genegurevich_at_discover.com>,        
             us>                       <oracle-l_at_freelists.org>            
                                                                        cc 
             08/14/2009 09:02                                              
             AM                                                    Subject 
                                       RE: GATHER_STATS_JOB                
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




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

Please consider the environment before printing this email.

--

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

Original text of this message