Using SEQUENCE - best practice for setting Cache value

  • Can anyone point me to some Best Practice documentation or share their experiences around setting a value for the Sequence Number Cache?

    We have a Sequence number generator which is serving multiple Databases, serving BIGINT values. This becomes very busy during the Data Load phase, and are experiencing SEQUENCE_GENERATION waits. The cache_size is currently set to 100.

    I am aware that the higher it's set, the more values would be lost in the event of an outage, I am just interested in suggestions around the Cache value, without us just increasing / monitoring for effect.

    Many thanks for your suggestions.

  • Thanks for the Response. I have read Joe's article, but he does not go into details of setting up the Cache - to quote "I am not going to explain Cache management. This is an implementation detail and I do programming."

    I am looking to get more information about how the Cache is best set / monitored.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply