Finding ROWID's locked
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Finding ROWID's locked

  1. #1
    Join Date
    Dec 2001
    Posts
    221

    Finding ROWID's locked

    We can find out the table which has been locked ( row-level) at a particular moment using v$lock, dba_dml_locks etc.

    But can we find out the "ROWIDS" which has been locked at a particular moment ???
    Santosh Jadhav
    8i OCP DBA

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I don't know of a methodology for doing that in general -- row lock info is stored at a low level within the table blocks themselves, not in any list external to the table, and i don't think there's a way of accessing the info directly.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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



Click Here to Expand Forum to Full Width