Re: Could you help me offering the similar scripts for manually gathering oracle statistics of system and production users?

Thank you so much Mladen, I'll find it on JL's blog and Tim Hall's. Happy New Year!

Best Regards
Quanwen Zhao

Mladen Gogala <gogala.mladen_at_gmail.com> 于2023年12月30日周六 02:08写道：

> On 12/29/23 07:51, Quanwen Zhao wrote:
>
> Hello my oracle gurus,
>
> One of financial customers in our company asks me to provide him the
> similar scripts for manually gathering oracle statistics of system and
> production users rather than automatically gathering oracle statistic jobs.
>
> Could you have the similar one? Thanks in advance.
>
> Best Regards
> Quanwen Zhao
>
>
> Hi Quanwen,
>
> Every script that I use uses some form of DBMS_STATS.GATHER_DATABASE_STATS
> configured by setting global prefs. The rest depends on what do you want to
> achieve. You can set clustering factor for some index, set some column
> statistics or lock table stats if necessary. I can't give you the exact
> script(s) because they belong to my employer. There are some sample scripts
> on Scratchpad or Tim Hall's Oracle-Base.
>
> Happy New Year!scr
>
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

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