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 .

August 31, 2004 | Filed Under Daily-Life 

Comments

4 Responses to “Oracle Sequecnes and Cache Value "20" mystery: Sequences with "cache" option can skip numbers”

  1. job opportunitya on November 21st, 2005 2:15 am

    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.

  2. job opportunitya on November 23rd, 2005 8:11 am

    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.

  3. job opportunitya on December 17th, 2005 6:34 am

    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.

  4. outa-time on January 25th, 2006 7:46 pm

    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!

Leave a Reply