Tuesday, August 31, 2004

Oracle Sequecnes and Cache Value "20" mystery: Sequences with "cache" option can skip numbers

Sequences with "cache" option can skip numbers Good article written here.

The default CACHE value for a sequence is 20, which means that after every 20 callsfor nextval Oracle has to update seq$ and refresh its cache.


Small tip over here about how to write sequences with or witout cache .


No comments: