-
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) ??
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|