Usage of XID fields in v$locked_object 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
    Chennai, India

    Usage of XID fields in v$locked_object

    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.

    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
    NOt sure whether you posted it on Metalink too but it seems identical to me
    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