Create Session Level General Performance Object: sessprocess
sessprocess
This object displays global information about all connected processes.
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
LOGON_TIME DATETIME Date/time the connection logged on
DATABASE_NAME VARCHAR Name of the current database
PROGRAM VARCHAR Program being executed
COMMAND VARCHAR Current command being executed
STATUS VARCHAR Current status of the connection
CPU NUMBER Total CPU used by the connection
MEMORY NUMBER Total memory used by the connection
WAIT_TIME NUMBER Total wait time experienced by the connection
BLOCKED_BY NUMBER Connection ID blocking the connection
CURRENT_SQL_HASH VARCHAR Currently executing SQL hash value
CURRENT_SQL TEXT Currently executing SQL (partial)
IDLE_SINCE_
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.