Re: Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS

something as simple as setting up a dimension table with hash values, low end of acceptable response time, high end of acceptable response time and a nightly report giving sql that doesn't fall into the accepted range would do the trick.

i'm not sure but i wouldn't be surprised if 10g has this out of the box.

On 11/22/05, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> Chris, so this means to check response time, and obviously register
> some response times, and
> make a backup of v$ related view to time of response, including execution paths?
>
> Sorry I'm slow to understand some matters, I don't work whole day in
> database, if you can help me please.
>
> Thanks
>

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