Blog » Blog Entry

Live Search:

Oracle's Silly Sequence Cache

April 9, 2008

The more I use Oracle the more I appreciate the lightweight nature of MySQL and even PostgreSQL for that matter. Right tool for the right job I guess :)

My latest Oracle issue seemed fairly odd at first. The issue was that I needed sequential numbers from my sequence, but Oracle was giving them to me in what seemed to be blocks of 20 at a time. Instead of 1.. 2.. 3.. 4, it would return 1.. 21.. 41.. and so on. Here's the fix, in a Rails migration since that's where I applied it:

class FixSeq < ActiveRecord::Migration

  def self.up
    execute "ALTER SEQUENCE USERS_SEQ NOCACHE"
  end

  def self.down
  end

end

My co-worker bud Bill helped me figure it out. Aside from being an awesome bassist, he's also an Oracle Guru.

Tags:

rubyonrails, oracle

« Christopher Hitchens Recommended Books

Two Rivers Ford in Nashville, TN are crooks »

Thanks!

By: Bill Graham <liam at liamgraham dot com>

Posted: 3 months ago

Dude, I checked my website traffic, and I've gotten hits from this. ;)

Thanks for the link and compliment...

Bill

Book Recommendation:

The Ruby Way takes a “how-to” approach to Ruby programming with the bulk of the material. It consists of more than 400 examples arranged by topic. Each example answers the question “How do I do this in Ruby?” Working along with the author, you are presented with the task description and a discussion of the technical constraints. This is followed by a step-by-step presentation of one good solution. Along the way, the author provides detailed commentary and explanations to aid your understanding. I highly recommend this book, especially for beginner to intermediate Ruby programmers.

Recent Blogs:

Random Quote:

When I was a boy I was told that anybody could become President. Now I'm beginning to believe it.

~Clarence Darrow