Create Session Level Contention Object: sesscurrwait

Registered by Aarti Pai on 2008-11-01

sesscurrwait
This object holds aggregate session information relating to current session waits.

Column Datatype Description
SERVER_ID NUMBER Server ID
SESSION_ID NUMBER Connection ID
USER_NAME VARCHAR Name of the user
USER_HOST VARCHAR Name of the user host
SQL_HASH VARCHAR Unique identifier for the SQL statement issued
WAIT_NAME VARCHAR The name of the wait event
WAIT_TIME NUMBER Total wait time for occurrence of wait
OBJECT_SCHEMA VARCHAR Database or schema of the object involved in wait
OBJECT_NAME VARCHAR Name of object involved in the wait
OBJECT_TYPE VARCHAR Type of object involved in the wait (table, index)

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
Brian Aker
Direction:
Approved
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.