Re: where can I find the latest SCN
Date: Thu, 19 Sep 2002 01:06:29 GMT
Message-ID: <Xns928DB8352A6AESunnySD_at_68.6.19.6>
pramod_at_rtimes.com (Pramod Ramachandran) wrote in 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
Maybe you are NOT clear on the concept of what FIRST_CHANGE# is for. Any given redo logfile will contain a RANGE of SCN values. The FIRST_CHANGE# value will NEVER change within a given copy of the redo logfile because it is the lowest value SCN within this file. Only when a logfile switch occurs can the LAST_CHANGE# be "locked down".
Simply put I contend that it is almost impossible to GUARENTEE you have the "latest SCN" or even the SCN for "your last COMMIT". The best you can do is determine in which redo logfile the committed transaction resides; along the the 1st & last SCN for that redo logfile. Received on Thu Sep 19 2002 - 03:06:29 CEST