Re: dbms_stats now that we are at 9.2

We had issues with gather_schema_stats and we moved over to gather_table_states and since then have peace of mind(9.2.0.6); I have an build script that we are using in production which i will mail you offline later today.

HTH
GovindanK

Kline.Michael wrote:

> Now that we are at 9.2 I can evaluate if we should go to dbms_stats
> now. There were enough bugs that nailed us with it that we had to stay
> with analyze before.
>
>
>
> I'm also looking for a script that may allow me to build a:
>
>
>
> BEGIN
>
> SYS.DBMS_STATS.GATHER_TABLE_STATS (
>
> OwnName => 'SYSADM'
>
> ,TabName => 'PS_FI_IVOL_R00'
>
> ,PartName => 'PS_FI_IVOL_R00_07'
>
> ,Granularity => 'PARTITION'
>
> ,Method_Opt => 'FOR ALL INDEXED COLUMNS SIZE 1 '
>
> ,Degree => 4
>
> ,Cascade => TRUE
>
> ,No_Invalidate => FALSE);
>
> END;
>
> /
>
>
>
> I'd like something where perhaps I could run a "@do_stats_partn owner
> table partition"
>
>
>
> I'll be tinkering with something soon, but maybe someone already has
> it and can save me the time.
>
>
>
> So, has anyone found a whole world of difference/improvement once they
> converted to dbms_stats. Our past problems were almost all partitions...
>
>
>
>
>
> Michael Kline
> Database Administration
> SunTrust Banks, Inc.
> Mail Code TOC-7505
>
> 1030 Wilmer Avenue
> Richmond, Va. 23227
> Tel: 804.261.9446 Net: 643.9446
>
> Cell: 804.744.1545
> michael.kline_at_suntrust.com <mailto:michael.kline_at_suntrust.com>
>
>
>
> **Seeing beyond Money**(sm)
>

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