Oracle Database Discussions

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!

Implications/side effects of changing cache size of sequence

orausernJul 19 2012 — edited Jul 19 2012

Hi Experts,

We are on Oracle 11.2.0.2 on Solaris 10. I have a question about sequences. They are defined as NOCACHE in my database and we are seeing a lot of "row cache lock". So I am thinking of changing the sequences to cache 20 values. Does this have any other implication -except that during db restart the cached values can be lost.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2012

Added on Jul 19 2012

#general-database-discussions

18 comments

3,140 views