There are two different options pursued when generating next values for sequences is concerned. One is CACHE option and the other one is NOCACHE. As far as replication of sequences is concerned, the use of one or the other option has certain implications. This solution explains what goes behind the scene as far as Shareplex (and to some extent Oracle) is concerned and why the CACHE option is preferred when replicating sequences in Shareplex.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center