SEQUENCE NUMBER GAPPING
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.