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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
