Re: How to find out a table last access time-stamp?

From: Noel <tbal_at_go2.pll-l>
Date: Fri, 25 Mar 2005 11:23:47 +0100
Message-ID: <d20p6u$473$1@inews.gazeta.pl>

Użytkownik dominica_at_gmail.com napisał:

> Hi All,
>
>
> I inherit this production database from someone.
> I need to find out a table's last access time-stamp?
> Whether it is READ or WRITE?
>

Personally, i would create table TABLE_ACCESS with, table_name, last_read_date, last_write_date columns.

Then i would create a script or procedure, which for each table in schema create a trigger on it after insert,select,update and delete. Trigger just update TABLE_ACCESS table.
No way in 8.1.7.4 to check system tables for last table access, i think.

-- 
Noel

Received on Fri Mar 25 2005 - 04:23:47 CST