SQL Object: syssqlwait

Registered by Aarti Pai on 2008-10-31

This object holds system information relating to SQL execution waits

Column Datatype Description
SERVER_ID NUMBER Server ID
SQL_HASH VARCHAR Unique identifier for the SQL statement
WAIT_EVENT VARCHAR Name of wait event
WAIT_COUNT NUMBER The times the particular wait occurred
WAIT_TIME NUMBER The total wait time (in mill or micro-seconds)
MAX_WAIT_TIME NUMBER The maximum single wait experienced for the event
OBJECT_SCHEMA VARCHAR The object schema that caused the wait
OBJECT_NAME VARCHAR The object name that caused the wait
OBJECT_TYPE VARCHAR The object type that caused the wait (table, index)
OBJECT_ENGINE VARCHAR The underlying engine of the object

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.