Skip to Main Content
Forums

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!

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.

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,

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 16 2012
Added on Jul 19 2012
#general-database-discussions
18 comments
2,968 views