(DI-2302) Collector for Oracle sessions
The technical name of the Collector for Oracle sessions is /DVD/MON_ORA_CL_COL_SESSION.
This collector collects basic information about Oracle database sessions, that represent users connected to the database. One user connection may have multiple sessions. It collects basic data like how many sessions are currently active or blocking, sessions per server, and the state of these sessions.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
|---|---|---|---|
ORA_SESS_ALL | Number of all active and blocking Oracle sessions | Count | Yes |
ORA_SESS_COMMIT | Number of currently committing Oracle sessions | Count | Yes |
ORA_SESS_ENQWAIT | Number of Oracle sessions waiting for enqueue | Count | Yes |
ORA_SESS_INST | Number of active and blocking Oracle sessions per host | Count | Yes |
Detail table
The collector provides a detailed table for Oracle active sessions. The technical name of the detail table is /DVD/MON_ORA_S_GORASESSION.
Oracle active sessions provide information about sessions that are Active or Inactive but blocking. It also provides more details about such sessions like user name, SQL details, or timestamps of the session. Records in detail table are aggregated from all servers.
Technical name | Description |
|---|---|
SERVER | Server name |
INST_ID | Oracle Instance ID |
ORASID | Session ID |
BLOCKING_SESSION | Oracle: Flag for blocking Session |
PADDR | Address of the process that owns the session |
USERNAME | Database user |
SQL_ADDRESS | SQL statement address that is currently being executed |
SQL_HASH_VALUE | SQL statement hash that is currently being executed |
SQL_CHILD_NUMBER | SQL statement ID that is currently being executed |
CLIENT_INFO | Client information |
CLIENT_IDENTIFIER | Client identifier of the session |
SPID | Operating System Process ID |
PROCPROG | Operating System Process name |
PROCESS | Operating System Process ID |
MACHINE | Operating system machine name |
SESSPROG | Operating system program name |
COMMAND | Command in progress |
STATUS | State of Session (Active, Inactive, Killed) |
TYPE | Session type |
EVENT | Event for which the session is waiting |
WAIT_TIME | Session's last wait time |
SECONDS_IN_WAIT | Seconds since the start of the last wait |
SQL_TEXT | Piece of SQL text |
P1TEXT | First additional parameter description |
P1 | First additional parameter |
P2TEXT | Second additional parameter description |
P2 | Second additional parameter |
P3TEXT | Third additional parameter description |
P3 | Third additional parameter |
MODULE | Program Name |
ACTION | Action name |
PGA_USED_MEM | PGA memory used |
PGA_ALLOC_MEM | PGA mem. allocated by process |
PGA_FREEABLE_MEM | Allocated PGA mem. which can be freed |
PGA_MAX_MEM | Max. allocated PGA mem. ever allocated by a process |
ROW_WAIT_OBJ | Row wait object ID |
ROW_WAIT_FILE | Row wait file |
ROW_WAIT_BLOCK | Row wait block |
ROW_WAIT_ROW | Current row locked in ROW WAIT |
WAIT_CLASS | Name of the wait class |