Re: where can I find the latest SCN

pramod_at_rtimes.com (Pramod Ramachandran) wrote in message news:<6616e304.0209180154.7bbeec36_at_posting.google.com>...
> Hi Steve, Ban
>
> Even I use Oracle 8i. I queried the v$log for the latest SCN. It has
> columns,
> It has a column FIRST_CHANGE# which becomes a new value larger than
> the previous one. But this does not happen when I do a COMMIT - it
> seems to update on a log switch.
>
> Thanks again and regards
>
> Pramod

In Oracle8i you can do a 'alter system checkpoint' then look at checkpoint_change# in v$datafile to get the latest commit SCN (checkpoint_change#-1, since checkpointing increments the SCN). Received on Wed Sep 18 2002 - 18:30:03 CEST