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

Home -> Community -> Usenet -> c.d.o.server -> Re: last block modify

Re: last block modify

From: Steve Robin <ocmaman_at_gmail.com>
Date: Tue, 17 Jul 2007 05:25:39 -0700
Message-ID: <1184675139.074367.68500@x35g2000prf.googlegroups.com>


On Jul 17, 4:45 pm, Steve Robin <ocma..._at_gmail.com> wrote:
> Is there any way to find when was last time block was modified(date
> and time) in oracle 9i.

I dump all blocks of that table and find this scn in it.

buffer tsn: 8 rdba: 0x024aec4d (9/715853) scn: 0x0693.d64b1f1c seq: 0x01 flg: 0x06 tail: 0x1f1c0601 frmt: 0x02 chkval: 0xfb07 type: 0x06=trans data

If it is SCN number and how to convert in number because in

select FIRST_CHANGE#,FIRST_TIME from v$loghist;

FIRST_CHANGE# FIRST_TIME

------------- ----------
8251619135862 29-JUN-07
8251619577230 29-JUN-07
8251620239229 29-JUN-07
8251620268048 29-JUN-07

so that this can be compare. Received on Tue Jul 17 2007 - 07:25:39 CDT

Original text of this message

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