Re: easy way to tell when table last accessed?

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 6 Oct 2004 23:00:15 GMT
Message-ID: <slrncm8tqj.3tk.rene.nyffenegger@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

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Wed Oct 06 2004 - 18:00:15 CDT

This message: [ Message body ]
Next message: Rene Nyffenegger: "Re: Two simple questions."
Previous message: Rene Nyffenegger: "Re: max and avg together"
In reply to: c: "easy way to tell when table last accessed?"
Next in thread: c: "Re: easy way to tell when table last accessed?"
Reply: c: "Re: easy way to tell when table last accessed?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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