Product iterations, using the same library, or just cleaning up data after migration, resulting in a sequence of billions, may have some impact, so reset, if production uses something, proceed with caution.

- execute commands generate results SELECT 'the alter sequence' | | SEQUENCE_OWNER | | '. '| | SEQUENCE_NAME | |' increment by '| | (SQ. MIN_VALUE - SQ.LAST_NUMBER + 500) || '; '||chr(10)|| 'select ' || SEQUENCE_OWNER || '.' || SEQUENCE_NAME ||'.nextval from dual; ' ||chr(10)|| 'alter sequence ' || SEQUENCE_OWNER || '.' || SEQUENCE_NAME ||' increment by ' || SQ.INCREMENT_BY || '; ' cmd FROM DBA_SEQUENCES SQ WHERE SEQUENCE_OWNER = '&USERNAME' AND SQ.LAST_NUMBER > 10000; Mysql > replace USERNAME with USERNAME