Re: ORACLE automatic update statistics better??
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Fri, 13 Aug 2010 10:14:36 -0500
That command looks appropriate. I am curious though how your consultant
wont 'let' you do anything, He after all, does work for you doesnt he?
And what do you mean manually update? dbms_stats.gather_table_stats?
On Fri, Aug 13, 2010 at 10:08 AM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
> 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
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
