Re: Stale statistic
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: jos1992831@xxxxxxxxxxxx
- Date: Mon, 23 Jan 2006 14:21:33 +0200
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@xxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
