Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: easy way to tell when table last accessed?
Romeo Olympia wrote:
> 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.
Sorry about hitting the "Send" button too soon. What I meant to say was:
Correct. Though if the table has indexes one can also monitor indexes for usage.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Oct 09 2004 - 14:16:34 CDT