Re: Stale statistic

From: Edgar Chupit <chupit_at_gmail.com>
Date: Mon, 23 Jan 2006 14:21:33 +0200
Message-ID: <a8f0771c0601230421r206c3bb7s63c5b0028c347232@mail.gmail.com>

Jos,

You can mine the logs to see if the table has not been changed, you can enable audit on that table, you can write your own dml trigger on that table to control who is modifying your tables, or you can simply enable tab monitoring to get this information.

Tab monitoring is very lightweight (especially in comparison with other methods) and an easy way to achieve what you need (as a bonus you will allow Oracle to gather statistics only for tables that do change).

On 1/23/06, Jos <jos1992831_at_yahoo.com.au> wrote:
> Hi list:
> Is it possible to identify stale statistic without turning on tab
> monitoring?
> Regards,
> Jos
>
>
> ________________________________
> Do you Yahoo!?
> The New Yahoo! Movies: Check out the Latest Trailers, Premiere Photos and
> full Actor Database.
>
>

--
Best regards,
  Edgar Chupit
  callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 23 2006 - 06:21:33 CST