RE: Question on NEXT_CHANGE#
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.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle
From: Mark W. Farnham [mwf_at_rsiz.com]
Sent: 31 December 2013 10:35
To: nassyambasha_at_gmail.com; riyaj.shamsudeen_at_gmail.com 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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nassyam Basha
Sent: Tuesday, December 31, 2013 2:54 AM
To: riyaj.shamsudeen_at_gmail.com
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 31 2013 - 20:18:31 CET