Re: Help on how to get decode the resource id

Hi Lakshmi,

The values of id1 and id2 depend on the type of lock. For example for a TM lock, id1 gives the object id, for a TX lock id1 gives the integer representation of the rollback segment (trunc(id1/65536) could be joined to the usn # of v$rollname to get the rollback). Joining the sid to v$session would give you the username.

Hope this helps. If you need further help, feel free to e-mail me and I can send you some scripts that come out of an oracle document (I can't remember the document number).

• Abhijit