SESSION_ID

NUMBER

Session identifier

OWNER

VARCHAR2(30)

Owner of the lock

NAME

VARCHAR2(30)

Name of the lock

TYPE

VARCHAR2(40)

Lock type:

• Cursor
• Table/Procedure/Type
• Body
• Trigger
• Index
• Cluster
• Java Source
• Java Resource
• Java Data

MODE_HELD

VARCHAR2(9)

Lock mode:

• None
• Null
• Share
• Exclusive

MODE_REQUESTED

VARCHAR2(9)

Lock request type:

• None
• Null
• Share
• Exclusive