Hi Friends,
Wishing you a Good Day !!
I have a query on a sequence cache reset in 12c Database. As I know the sequence cache is at DB level in 12c , but what I am looking for is that the reasons where the cache is reset
Sequence
CREATE SEQUENCE DOC_SEQ
MINVALUE 1 MAXVALUE 9999999999
INCREMENT BY 1 START WITH 3000175009 CACHE 5000 NOORDER NOCYCLE NOPARTITION ;
As you can see the CACHE value is 5000 , but we are seeing in our DB the sequence's CACHE is getting lost for some reasons . From our analysis it is found that any restart of DB will reset the CACHE , but even there is no restart in DB CACHE is getting lost . Is there any values (reset time) at DB level which will reset the CACHE value
Note: I am not looking for the nextval function where the number will be lost , if the number is not used
Regards,
SH