Scalable sequence session prefix size
From: Thomas Ranchon <thomas_at_ranchon.org>
Date: Fri, 30 Apr 2021 15:59:14 +0200
Message-ID: <CAJNN_2Sxy4At6DuoYQNLhzGkdH0OHvFXW_=tyJZJsCwpL=Ng_g_at_mail.gmail.com>
Hi all,
Date: Fri, 30 Apr 2021 15:59:14 +0200
Message-ID: <CAJNN_2Sxy4At6DuoYQNLhzGkdH0OHvFXW_=tyJZJsCwpL=Ng_g_at_mail.gmail.com>
Hi all,
I have an insert statement that is using a scalable sequence to generate an
id.
This insert statement is running in PARALLEL(16) mode.
Sometimes duplicate ids are generated because 2 of the 16 sessions doing
the insert share the same (session_id%1000) that is used by the scalable
sequence to make the session prefix of the sequence.
Is there a way to increase the size of the session prefix in the sequence that would avoid those duplicates ids ?
Thank you and best regards
Thomas Ranchon
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 30 2021 - 15:59:14 CEST