Re: [Q] way to check table last modify time?

From: Jeremy Paul Schneider <jeremy.schneider_at_ardentperf.com>
Date: Wed, 25 Apr 2007 12:47:32 -0500
Message-ID: <18be0f260704251047m3d741421mc1c492bb46097cc6@mail.gmail.com>

In 10g you can do this rather easily and somewhat precisely for any table modified within the past 5 days.

SQL> select scn_to_timestamp(max(ora_rowscn)) from t2;

SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))

---

25-APR-07 12.41.01.000000000 PM For tables modified more than 5 days ago you can see the SCN but cannot translate into a timestamp. (At least, according to metalink note 361480.1) You could possibly keep track of SCN's yourself for a longer period and translate it yourself.

On a related note you can even see last modified time on each *row* without your own custom fields if you enable dependancy tracking. This will use a little extra space for each row; basically Oracle is going to save the last modified SCN for each row rather than the default of each block.

-Jeremy

On 4/25/07, Mark Strickland <strickland.mark_at_gmail.com> wrote:
>
> I'm using LogMiner for this sort of thing. Lower performance impact than
> auditing from what I've read.
>
> Mark
>
>

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 25 2007 - 12:47:32 CDT