Database Software

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!

Sequence caching in RAC

PVMSep 9 2013 — edited Sep 10 2013

Hi All,

Production server configuration is 4 node RAC. Version is 11.2.0.3. Linux Platform. We are using sequences in DB.

I was reading some blogs on sequence working on RAC env. I came to know a sequence with cache noorder will improve the performance.But i have not seen how can we cache a sequence properly in RAC.Can you please let me know your suggestions for the below questions?

When we create any sequence, how can we cache a sequence properly on 4 instances?

How can we calculate the cache for each instance?

How shall we know whether sequence is using or not?

Thanks,

Mani

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2013

Added on Sep 9 2013

#performance-availability, #real-application-clusters

4 comments

1,266 views