PL/SQL (MOSC)

MOSC Banner

SEQUENCE NUMBER GAPPING

edited Nov 20, 2015 4:45PM in PL/SQL (MOSC) 6 commentsAnswered

I've read lots of documentation about gaps in sequence numbers and I understand that Oracle does not guarantee gapless sequences.  That's fine, I do not require gapless.  But as system volumes have increased, I am looking to ensure gapping is minimized so that the 'rolling' of the sequence number does cause sequence numbers to be reused in the same day.


I have a sequence number that goes from 1 to 99999, increments by 1, cache is 20.  When 99999 is hit, the system will roll the number to 1 and keep going.  With recently increased volume, we can now end up trying to reuse a sequence number that was used earlier in the day, causing errors.  My goal is to reduce the gapping to prevent this, even at the cost of higher IO.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center