Create Session Level Contention Object: sesscurrwait
Registered by
Aarti Pai
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:
-
future
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
(?)
Work Items
Dependency tree
* Blueprints in grey have been implemented.
