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.