Usage of XID fields in v$locked_object
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Usage of XID fields in v$locked_object

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Usage of XID fields in v$locked_object

    hi,
    I would like to know,

    1. The actual usage of XIDUSN, XIDSLOT, XIDSQN fields in v$locked_object ?

    2. When these values gets modified ?

    3. Assume a situation where i have 2 tables(table1 and table2) locked in session 1. If i try to insert a row for table1, all the XID details in session 1 gets modified to the same value.

    eg.
    after locking table1 and table2,
    XIDUSN = XIDSLOT = XIDSQN = 0 for both the tables.

    after insertion of row to table1,
    XIDUSN = 10, XIDSLOT = 28, XIDSQN = 659 for both the tables. (same XID for table1 and table2)

    a) Why is that both tables XID in the same session gets modified ?

    b) IS there chances to get different XID in the same session??

    c) Is it possible to have more than one row (from v$locked Object) of same session id and Object_id (field that shows the locked object uniquely) ??

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    NOt sure whether you posted it on Metalink too but it seems identical to me

    http://metalink.oracle.com/metalink/..._id=473256.995
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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