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 .


4 comments:

job opportunitya said...

Unique blog my friend, I can hardly wait to vist
this site again. I just worship the site its comes
from! Believe me in my extra time I'm consistently
looking up blogs like this.
Please discover my arizona center plastic surgery tucson az blog.

job opportunitya said...

I surf the web looking for blogs like this one.
Your site was on point and will be back again! Awesome
blog.
Look into my plastic surgery houston blog.

job opportunitya said...

Incredible blog. I admired your site and I will be
back once again to view it! I use much of my spare
time searching for blogs like yours.
Sweetie, go and search my blog for what you need.

outa-time said...

I surf the web looking for blogs like this one.
Your site was on point and will be back again! Awesome
blog.
Check out my online cash advance blog, please!