Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: last block modify
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