Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Sequence Cache reset in 12c

Shamed HAug 27 2019 — edited Aug 29 2019

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
This post has been answered by Sven W. on Aug 27 2019
Jump to Answer

Comments

Post Details

Added on Aug 27 2019
#sql-pl-sql
9 comments
3,223 views