Re: easy way to tell when table last accessed?

Just a note that Daniel must have forgotten to mention.

The MONITORING clause for tables, the main purpose of which is for detecting "staleness" of statistics for automated gathering, will only record DMLs done on the table (eg. UPDATE, INSERT, DELETE). So if the OP defines "last accessed" as including plain queries, then this will not cover that.

Cheers!

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097197964.796816_at_yasure>...
> c wrote:
>
> > Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote in message news:<slrncm8tqj.3tk.rene.nyffenegger_at_zhnt60m34.netarchitects.com>...
> >
> >>In article <250e5e6c.0410061250.3f69c474_at_posting.google.com>, c wrote:
> >>
> >>>We need to identify old unused tables and wondering if anyone knows
> >>>nifty commands for determining this? Thanks.
> >>
> >>Look into audit (SQL). However, you need to audit the tables in question
> >>for a while in order for it to be usable for your purposes.
> >>
> >>hth
> >>Rene
> >
> >
> > Silly me. The oracle version is 9.2.0.3
> >
> > c
>
> Then seriously consider the MONITOR clause for CREATE TABLE and ALTER TABLE.
Received on Fri Oct 08 2004 - 03:42:46 CDT