Contention Objects: sysobjwaits
sysobjwaits
This object holds system information relating to object specific waits
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
WAIT_NAME VARCHAR Name of wait event
WAIT_COUNT NUMBER Number of times the wait occurred
WAIT_TIME NUMBER Total wait time for the observed wait event (in milliseconds)
MAX_WAIT_TIME NUMBER The maximum single wait experienced for the event
Notes:
A wait category (such as “I/O”) could be included.
A SQL object also includes waits. Given that objects can only be accessed via SQL, sysobjwaits may not be necessary.
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:
- future
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Work Items
Dependency tree
* Blueprints in grey have been implemented.