Sessions
(SID, SERIAL#)
| Name | Data Type | Description |
|---|---|---|
| SID | long | Session ID |
| SERIAL# | long | Session serial # |
| LOCKWAIT | string(20) | Address of lock being waited on, if applicable |
| BLKBY_INST | long | Instance ID of blocker session, if applicable |
| BLKBY_INSTNAME | string(20) | Instance name of blocker session, if applicable |
| BLKBY | long | Session ID of blocker session, if applicable |
| BLKCNT | long | Approximate number of sessions being blocked by this session |
| SESSION_USER | string(32) | Login name |
| PROGRAM | string(52) | Application name |
| OSUSER | string(32) | Client OS user name |
| STATUS | string(12) | Status (ACTIVE, CACHED, INACTIVE, KILLED, SNIPED) |
| SERVER | string(12) | Server type (DEDICATED, NONE, PSEUDO, SHARED); the usual value is DEDICATED |
| CMD_CODE | long | General command type # |
| TERMINAL | string(32) | Client host name |
| SESSION_TYPE | string(12) | Type (BACKGROUND, USER) |
| SQL_ID | string(16) | SQL ID |
| SQL_CHILD_NUMBER | long | Child # for the SQL; one SQL statement may have multiple child cursors due to environment differences between sessions |
| COMMAND | string(32) | General command type name; see view AUDIT_ACTIONS for possible values |
| PID | long | Oracle process ID; not related to OS process ID |
| SPID | string(28) | OS Process ID (PID) for session; not unique if threaded_execution = TRUE (not related to MTS / SHARED server type) |
| PROCESS_USER | string(16) | OS process user name for session |
| LOGRDS | double | Number of logical reads (db block gets + consistent gets) |
| PHYRDS | double | Number of physical reads (physical reads) |
| WRITES | double | Number of physical writes (physical writes) |
| LOGON_TIME | time | Login time |
| EVENT | string(68) | Current wait event, if applicable |
| P1TEXT | string(68) | First wait event parameter, as text, if applicable |
| P1 | double | First wait event parameter, as a number, if applicable |
| P1RAW | string(20) | First wait event parameter, as raw, if applicable |
| P2TEXT | string(68) | Second wait event parameter, as text, if applicable |
| P2 | double | Second wait event parameter, as a number, if applicable |
| P2RAW | string(20) | Second wait event parameter, as raw, if applicable |
| P3TEXT | string(68) | Third wait event parameter, as text, if applicable |
| P3 | double | Third wait event parameter, as a number, if applicable |
| P3RAW | string(20) | Third wait event parameter, as raw, if applicable |
| SECONDS_IN_WAIT | double | if waiting: duration of wait time, in seconds; if not waiting: duration of time since session switched between ACTIVE and INACTIVE states (either way), in seconds |
| CPUHSECS | double | CPU time, in 100ths of a second (CPU used by this session) |
| MEMORYKB | long | Memory usage, in kilobytes [(session pga memory + session uga memory) / 1024] |
| USER_CALLS | long | Number of user calls (user calls) |
| MODULE | string(52) | Application module name |
| CLIENT_INFO | string(68) | Application client info |
| ACTION | string(36) | Application action |
| LAST_CALL_ET | double | Duration of time since session switched between ACTIVE and INACTIVE states (either way), in seconds |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| LOGRDS_DELTA | double | Delta number of logical reads |
| PHYRDS_DELTA | double | Delta number of physical reads |
| LOGIO | double | Number of logical IO operations (logical reads + physical writes) |
| MISS_PCT | double | Data cache miss %, or how often logical reads required physical reads |
| LOGWRTS_DELTA | double | Delta number of physical writes |
| LOGIO_DELTA | double | Delta number of logical IO operations |
| LOGIO_AVG | double | Average of delta number of logical I/O operations, since collection started |
| LOGIO_MAX | double | Maximum of delta number of logical I/O operations, since collection started |
| CPUPCT | double | CPU % Used (1 CPU), in interval |
| CPUPCT_AVG | double | Average CPU % Used (1 CPU), since collection started |
| CPUPCT_MAX | double | Maximum CPU % Used (1 CPU), since collection started |
| Attributes: | None |
|---|---|
| Minimum database version: | 8.1 |