Contention Objects: sysobjwaits

Registered by Aarti Pai on 2008-10-31

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:
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.