Contention Objects: syslocks

Registered by Aarti Pai on 2008-10-31

This object holds system information relating to all locks.

Column Datatype Description
SERVER_ID NUMBER Server ID
OBJECT_SCHEMA VARCHAR Database or schema of the object
OBJECT_NAME VARCHAR Name of object involved in the lock
OBJECT_TYPE VARCHAR Type of object involved in the lock (table, index)
OBJECT_ENGINE VARCHAR The underlying engine of the object
SESSION_ID NUMBER Connection ID
USER_NAME VARCHAR Name of the user hold the lock
USER_HOST VARCHAR Name of the user host holding the lock
LOCK_TYPE VARCHAR Type of lock (exclusive, etc.)
LOCK_LEVEL VARCHAR Level of lock (page, row, etc.)
LOCK_STATE VARCHAR State of lock (granted, waiting)
LOCK_TIME NUMBER Duration of the lock (in milliseconds)
BLOCKING CHAR Whether the lock is blocking another lock (Y,N)
BLOCKED_BY NUMBER Session ID being blocked (NULL is not blocking)
BLOCKED_TIME NUMBER Time being blocked (in milliseconds)

Notes:

Quick lock information will also be found in sessprocess.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
Brian Aker
Direction:
Needs approval
Assignee:
None
Definition:
Approved
Series goal:
Accepted for trunk
Implementation:
Not started
Milestone target:
milestone icon future

Related branches

Sprints

Whiteboard

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.