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.