Hi
Code:
Session 15: obj - rowid = 000042AB - AAAEKrAAgAAAkQ0AAA
Sid 15 was waiting for ROWID 'AAAEKrAAgAAAkQ0AAA' of object 0x42AB
(which is 17067 in decimal)
Code:
Session 33: obj - rowid = 000042B4 - AAAF5qAAKAAAUM0AAF
Sid 33 was waiting for ROWID 'AAAF5qAAKAAAUM0AAF' of object 0x42B4
(which is 17076 in decimal)
You can find out the object name and object type as:
Code:
select owner,object_name,object_type from all_objects where object_id=17067;
select owner,object_name,object_type from all_objects where object_id=17076;
You can further dig down by :
Here the owner and the object_name is the result of the above querries.
Code:
select * from owner.object_name where ROWID='AAAEKrAAgAAAkQ0AAA';
select * from owner.object_name where ROWID='AAAF5qAAKAAAUM0AAF';
HTH