meaning of a "lock name"

n_i · #1 (**permalink**) 04-12-04, 12:22

I'm just wondering if any meaningful information can be obtained by interpreting a lock name as it appears in the lock snapshot, e.g.

Code:

Lock Name                   = 0xA6B2A69FA4A17C7D9176505041

nitingm · #2 (**permalink**) 04-13-04, 03:48

Hi,

This seems a hexadecimal code. We have tried many options to intercept what it is all about however we have had no success.

Please let us know if you have some break through.

Thanks in Advance.

J Petruk · #3 (**permalink**) 04-13-04, 08:25

The documentation says:
"Internal binary lock name. This element serves as a unique identifier
for locks."

What more do you need? Curious.

jono

Marcus_A · #4 (**permalink**) 04-13-04, 08:34

For a row lock, I think it is the table id and RID.

n_i · #5 (**permalink**) 04-13-04, 09:19

Quote:

Originally posted by J Petruk
The documentation says:
"Internal binary lock name. This element serves as a unique identifier
for locks."

What more do you need? Curious.

It is I who is curious :-)

J Petruk · #6 (**permalink**) 04-13-04, 09:37

Quote:

Originally posted by n_i
It is I who is curious :-)

You spent all Easter thinking about this, didn't you?

There seems to be some pattern to it, locks of the same type seem to share the same characters, locks on the same table seem to share some characters... I doubt they publish anything official on the subject though.

I think it goes tablespace id -> object id (table) -> a bunch of other stuff -> lock type (row/mode)?

sathyaram_s · #7 (**permalink**) 04-13-04, 12:42

Does it name include the database seed also ?

Cheers
sathyaram

Quote:

Originally posted by J Petruk
You spent all Easter thinking about this, didn't you?

There seems to be some pattern to it, locks of the same type seem to share the same characters, locks on the same table seem to share some characters... I doubt they publish anything official on the subject though.

I think it goes tablespace id -> object id (table) -> a bunch of other stuff -> lock type (row/mode)?

Internet Services

Web Development

Digital Marketing

Consumer Tech