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