Re: last block modify

From: sybrandb <sybrandb_at_gmail.com>
Date: Tue, 17 Jul 2007 06:11:17 -0700
Message-ID: <1184677877.677553.22450@g37g2000prf.googlegroups.com>

On Jul 17, 1: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.

Apart from having to dump a block, what is the pressing business need? Just curiousity? Management Information? The closest you will get is by using logminer. But as logminer loads redo log files in the shared pool, this should be a rare exception.

--
Sybrand Bakker
Senior Oracle DBA

Received on Tue Jul 17 2007 - 08:11:17 CDT