system dump------------Enqueue State Object

Example:
(enqueue) MR-00000008-00000000 [O8: DID: -- ]
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res:304c7fc, mode: S, prv: 304c804, sess: 3024c5c, proc: 301dd30

Meaning:
Following the (enqueue) we have the enqueue resource type with id1 and id2

In Oracle8 'DID' is the deadlock.

lv.............16 byte array that defines the lock value.
                (See sc.h and the typedef'd struct 'scgv').
res............Address of resource.
mode or req....Lock mode held or requested. Normally 'mode:' and 'req:'
                are mutually exclusive but it is possible for a process to
                hold a lock at one level and be requesting it at a higher
                level.
prv............Previous pointer in a linked list. The values of mode
                and req determine the list we are on as follows :
                  - No mode and No req = Not on a list
                  - No mode and req    = On waiter list
                  - Mode and no req    = On owner list
                  - Mode and req       = On converter list
sess...........Address of session (state object) who has acquired the
                resource.
proc...........Address of the process state object that owns the session
                given in 'sess'.

Comments
~~~~~~~~
  o I have only every seen 'lv:' followed by a string of zeros as in the
    example.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16158219/viewspace-605701/，如需转载，请注明出处，否则将追究法律责任。