sequence caches and synonyms
From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Tue, 6 Nov 2018 18:14:38 +0000
Message-ID: <CACH2EDJWEq=Fs0iD3MwbotpsQjgoV-=CJso9q+n9UbDk8KHgKA_at_mail.gmail.com>
Strange situation here,
Date: Tue, 6 Nov 2018 18:14:38 +0000
Message-ID: <CACH2EDJWEq=Fs0iD3MwbotpsQjgoV-=CJso9q+n9UbDk8KHgKA_at_mail.gmail.com>
Strange situation here,
We noticed that if we ask a package to return the next value which would be used for a table entry (done using a sequence), we get a number.
If we go through a local synonym to ask the same package to answer the same question, we receive a slightly different answer.
Is it possible that there are two caches of sequences values, depending on how the package which refers to the sequence is executed? I suppose if two users are entering records concurrently in the same table, they each have their own set of cached sequence values (?).
We don't think this happened in 11g, it only seems to be happening in our 12.2 databases.
I will log an SR as well, just thought I might ask this list first.
- Patrice My profiles: [image: Facebook] <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image: LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image: Twitter] <http://www.twitter.com/PatriceBoivin>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 06 2018 - 19:14:38 CET