Help on how to get decode the resource id

Hello everyone,

Can anyone tell me as how to get the exact resource from the v$lock using id1 and id2. I read somewhere that id1 will help in fetching the object from the all_objects.

My question is how do i get a particluar record that is being locked by a particular process when o see the id1, id2. does id1, id2 point to a table/row or can it be any other resource.

Thanks a lot in advance .

Lakshmi Prasad Received on Tue May 06 1997 - 00:00:00 CDT