Re: Could you help me offering the similar scripts for manua

A big thanks for your suggestion, probably he just wanna adjust the time of the oracle default maintenance windows and or just add several prefs for special tables and add locking the statistics of specified tables (but still using automatic statistics collection task).

Hope you continue to enjoy your retirement time.

Best Regards
Quanwen Zhao

richard goulet <rjgoulet_at_comcast.net> 于2024年1月1日周一 01:41写道：

> I will provide a word of warning here.
>
> Statistics are a real pain in the neck since most users do not
> understand how they are used, how they are computed, and why they don't
> get the results they expect and that goes for significant number of
> dba's as well. As a result I do not recommend manual stats computation
> scripts or giving users access to run them.
>
> I had a number of "educated users" who demanded stats computation
> rights because a particular index was or was not used in their query
> they way they believed it should. Many don't understand that
> "upper(column_name)" kills indexes because of the function call, nor do
> they understand why "user_function_call(column_name)" does or does not
> cause a index to be used. or why an indexed column with 99% redundancy
> isn't used.
>
> For sanity's sake keep that functionality away from users.
>
>
> Richard Goulet
> Principle Oracle DBA
> Now in retirement & loving it.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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