Re: Question on NEXT_CHANGE#

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Mon, 30 Dec 2013 19:12:24 +0530
Message-ID: <CAABGLuL+Yv-Cda-g08b624YW8dbcVVuG+bQvm7XkeZ_du+z0cQ_at_mail.gmail.com>



Jonathan, Thomas

I have picked up SCN from the Log Miner and crosschecked all the SCN information. As youíve already guessed, I can see there is no consistency in the order. Gaps are not coherent as shown below:

 *Sequence 31 the first_change# is 2432612:*

  1. 2432614 then 2432617 - in between 3 are missing
  2. 2432623 then 2432626 - in between 3 are missing
  3. 2432639 then 2432642 - in between 3 are missing
  4. 2432648 then 2432650 - in between 2 are missing
  5. 2432663 then 24332665 - in between 1 is missing

It seems that there are interval gaps taken place. I think that, in between, there are few system changes. Isnít it?

  • Nassyam Basha
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 30 2013 - 14:42:24 CET

Original text of this message