I have just posted a lengthy article about how Oracle uses rowid. It starts with talking about blocks , and how they work. Then I discuss how rowid are used and represented in symbolic dumps. Normal uses such as index linking to a data segment as well as migrated and chained rows are discussed. The document finishes with a brief discussion on how ITL works on the block and the relation between ITL and locking on the original block a row was first placed on (before it was migrated or chained).

This article is the basis for the presentation I will hold tomorrow at the Orcan conference. If you will join us for the conference, come see the presentation. ROWID and block dumps are pretty fascinating stuff. This is one area where Oracle’s internals really impresses. Learning how Oracle built the database usually teaches me a few new things about how interesting problems can be solved in clever ways.

This blog post will be the permanent place for comments, updates, and discussions about this document. I intend to translate this document to English soon, as I have been asked to provide an excerpt of this for publication in the US.

4 Comments

  1. Kostas Hairopoulos

    did you find the time to translate? When its available, please keep us posted
    thx
    khair

  2. The english version of the article is finally uploaded. Sorry it took so long. The article is on the article page on my website (http://mathiasmagnusson.com).

  3. Gordon Rose

    Hi, supposedly the article is at
    https://oradbdev.mathiasmagnusson.com/article/
    but I find only the abstract. Where can the full article (in English) be found? Thanks,
    Gordon

  4. Gordon,
    I’m sorry. That post should have included a link to my articles page. All my articles are listed on https://mathiasmagnusson.com/iweb/Oracle_Articles.html.
    There is a comment there about an excerpt being published. That refers to what was published, not to the article linked. The article linked is the full article on the subject.
    Let me know if this helped or if you’re still not finding the article you’re looking for.
    Mathias

Leave a Comment

Your email address will not be published. Required fields are marked *