RE: ORACLE automatic update statistics better??
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Aug 2010 15:13:56 +0000
The Oracle provided job will gather histograms by default and that is pretty
the main difference from the statistics collection command you posted.
You should not need to manually gather statistics except in those cases where
you create and load a new table and want statistics now rather than wait on the
Oracle job task to generate statistics and in those cases where the generated
statistics do now work well. You may be better off without histograms on a
specific table, etc....
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of dba1 mcc
Sent: Friday, August 13, 2010 11:09 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: ORACLE automatic update statistics better??
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
