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

Posted by Rajesh Shetty on August 31, 2004

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 .

Trackbacks

Use this link to trackback from your own site.

Comments

Leave a response

  1. job opportunitya Mon, 21 Nov 2005 02:15:00 EST

    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 Wed, 23 Nov 2005 08:11:00 EST

    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 Sat, 17 Dec 2005 06:34:00 EST

    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 Wed, 25 Jan 2006 19:46:00 EST

    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!

Comments