ORACLE automatic update statistics better??

From: dba1 mcc <mccdba1@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 13 Aug 2010 08:08:36 -0700 (PDT)

we have ORACLE 10GR2 on LINUX server.  Our consultant don't allow us "manually" 
to run "update statistics".  Consultant say ORACLE 10GR2 automatic update 
statistics algorithm better than manually command.

The SQL command we used to manually run is:

execute DBMS_STATS.GATHER_SCHEMA_STATS (ownname=> UPPER('&ID'), 
estimate_percent=> dbms_stats.auto_sample_size, method_opt=> 'FO
R ALL INDEXED COLUMNS SIZE 1', DEGREE=> DBMS_STATS.DEFAULT_DEGREE, 
cascade=>TRUE)

I would like listen your opinion.

Thanks.


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

Follow-Ups:

Re: ORACLE automatic update statistics better??
From: Andrew Kerber

RE: ORACLE automatic update statistics better??
From: Powell, Mark

Re: ORACLE automatic update statistics better??
From: Greg Rahn

ORACLE automatic update statistics better??

Other related posts: