Hello friends
I am using a sequence for populating data in a table. It is generating the numbers sequentially for the entire day but next day it starts with a gap of about 15 to 20.
The following are the profiles of my sequence:
MIN_VALUE 1
MAX_VALUE 9999999999999999999999999999
INCREMENT_BY 1
CYCLE_FLAG N
ORDER_FLAG Y
CACHE_SIZE 0
LAST_NUMBER 2234
PARTITION_COUNT null
SESSION_FLAG N
KEEP_VALUE N
I shall be thankful if someone can point the reason why I am not getting the sequence numbers sequentially.
Regards
Hawker