Re: Question on NEXT_CHANGE#
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>, Thomas P S <royxavier@xxxxxxxxx>
- Date: Mon, 30 Dec 2013 19:12:24 +0530
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
Other related posts:
