RE: Question on NEXT_CHANGE#

From: Jonathan Lewis <>
Date: Tue, 31 Dec 2013 19:18:31 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DD3A0A_at_exmbx05.thus.corp>

I came quite close to asking a similar question before you responded - so I will now.

There are many things where it might be quite interesting to know the answer when it's not really something that anyone needs to know (I think someone else has already made that point).

Is the gap actually causing a problem, or is this simple curiosity - if the latter then it's a little optimistic to hope that someone else use their time to expand the answer that they've already given; if the former then you need to describe the perceived problem in case (a) the gap has nothing to do with it, and (b) there is a solution that someone would be able to give you if they weren't led astray by the discussion of the gap.

Jonathan Lewis

From: Mark W. Farnham []
Sent: 31 December 2013 10:35
To:; Cc: 'Phillip Jones'; 'ORACLE-L'; Jonathan Lewis Subject: RE: Question on NEXT_CHANGE#

Having reviewed the thread, Iím a bit curious what the actual question is and whether there is a problem of any kind. Perhaps this is only a research question (which is fine)

From: [] On Behalf Of Nassyam Basha Sent: Tuesday, December 31, 2013 2:54 AM To:
Cc: Phillip Jones; ORACLE-L; Jonathan Lewis Subject: Re: Question on NEXT_CHANGE#

Hi Riyaz,

Thanks for the points you mentioned on kcmgas and behaviour of it, What are the possible reasons for the increments in SCN which may not recorded and not visible to us.

Received on Tue Dec 31 2013 - 20:18:31 CET

Original text of this message