Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: easy way to tell when table last accessed?

Re: easy way to tell when table last accessed?

From: c <barneytoe_at_gmail.com>
Date: 7 Oct 2004 08:36:22 -0700
Message-ID: <250e5e6c.0410070736.cee0c88@posting.google.com>


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 Received on Thu Oct 07 2004 - 10:36:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US