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!

CONFUSED with Cache size versus Increment by in Sequence

568915Jun 4 2009 — edited Jun 4 2009

Dear all,

I have a sequence that has the following attributes
MINVALUE 1
MAXVALUE 9999999999999
CACHE SIZE 20
INCREMENT BY 1

and tested with SELECT * FROM all_sequences and verified the above attributes.

The issue is when used, it started at 21 and has been incrementing by 20. Is it because of the Cache size overriding Increment by? I am totally confused. Please help...

Thank you,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2009

Added on Jun 4 2009

5 comments

1,423 views