Results 1 to 3 of 3

Thread: OD lock ???

  1. #1
    Join Date
    Aug 2008
    Posts
    45

    Unanswered: OD lock ???

    Hey folks,

    I'm doing some analysis about index rebuilding lately, and I found that when rebuilding index offline, when I see the lock type in v$lock, it turns out to be "OD", I've searched all the resources that I got, but I couldn't find that OD lock type. Does anyone know this ???

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    offline locks the table.
    indexes don't need to be rebuilt however.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Aug 2008
    Posts
    45

    Thankz

    Thank you for the reply, and yeah, after reading many developers comments an blogs, it seems that index rebuilding is a only necessary at rare times, and for addition, I finally managed to find the "OD" meaning when lookin' at its description at v$lock_type. It most likely stands for "Online DDL"

    The view also contains the description of a whole bunch of undocumented lock types too, like AE, etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •