Re: last_time is always NULL in v$datafile

From: Andreas <andreas.prusch_at_t-online.de>
Date: 6 Feb 2002 05:37:24 -0800
Message-ID: <c071e7da.0202060537.72e9e3c3@posting.google.com>

This columns reflects header information and should be available in mout state, or can be printed with datafile header dump.
It doesn't make sense to keep this information actual, because this must be changed at least with every dml operation.

Best regards,
Andreas

sebastian.rickmann_at_csfs.com (Pulsedriver) wrote in message news:<31a1f8b3.0202060352.42f62e30_at_posting.google.com>...
> Hi!
>
> I am just wondering why in v$datafile the attributes last_time and
> last_change# are NULL for all datafiles.
> I have set TIMED_STATISTICS = TRUE.
> I'm running Oracle 8.1.7.
> All the datafiles are raw volumes (UNIX).
> Thanks for any hints!
Received on Wed Feb 06 2002 - 07:37:24 CST