Re: Question on NEXT_CHANGE#
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 30 Dec 2013 08:37:38 -0700
Message-ID: <52C19342.5000203_at_gmail.com>
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?
Date: Mon, 30 Dec 2013 08:37:38 -0700
Message-ID: <52C19342.5000203_at_gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 30 2013 - 16:37:38 CET