Re: Question on NEXT_CHANGE#

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 30 Dec 2013 08:37:38 -0700

On 30/12/2013 6:42 AM, Nassyam Basha wrote:
It seems that there are interval gaps taken place. I think that, in between, there are few system changes. Isn't it?

Is there any DB Link in the system?

My experience is that SCNs are not guaranteed to be gapless, especially in situations where inter-database communication is possible.

I would also ask whether that DB uses private redo.
/Hans

Other related posts: