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
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:*
- 2432614 then 2432617 - in between 3 are missing
- 2432623 then 2432626 - in between 3 are missing
- 2432639 then 2432642 - in between 3 are missing
- 2432648 then 2432650 - in between 2 are missing
- 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-lReceived on Mon Dec 30 2013 - 14:42:24 CET