Sequence Dynamic Cache Resizing

With dynamic cache resizing the sequence cache size is now auto-tuned based on the rate of consumption of sequence values.  This means the cache can automatically grow and shrink over time depending on usage, while never falling below the DDL specified cache size. By dynamically resizing the cache, performance can be improved significantly, especially for fast insert workloads on RAC, by reducing the number of trips to disk needed to replenish the cache.

Dynamic cache resizing can improve performance significantly for fast insert workloads that use sequences. This is accomplished by reducing the number of trips to disk needed to replenish the sequence cache and can be especially significant in a RAC environment.

Related Topics