Create Session Level General Performance Object: sessprocess

Registered by Aarti Pai on 2008-11-01

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_LAST_CALL NUMBER Amount of time (seconds) since last call completed

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.