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 .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment