| SID |
Session ID |
| Serial# |
Session serial # |
| User |
Login name |
| Status |
Status (ACTIVE, CACHED, INACTIVE, KILLED, SNIPED) |
| Last Command |
General command type name; see view AUDIT_ACTIONS for possible values |
| Logical I/O |
Delta number of logical reads +
Delta number of physical writes |
| Program |
Application name |
| CPU % (One CPU) |
CPU % Used (1 CPU), in interval |
| Cache Miss % |
Data cache miss %, or how often logical reads required physical reads |
| Blk Cnt |
Approximate number of sessions being blocked by this session |
| Blked By |
Session ID of blocker session, if applicable |
| Blked By Inst Name |
Instance name of blocker session, if applicable |
| Module |
Application module name |
| Client Info |
Application client info |
| Action |
Application action |
| Terminal |
Client host name |
| Server |
Server type (DEDICATED, NONE, PSEUDO, SHARED); the usual value is DEDICATED |
| PID |
Oracle process ID; not related to OS process ID |
| SPID |
OS Process ID (PID) for session; not unique if threaded_execution = TRUE (not related to MTS / SHARED server type) |
| Server OS User |
OS process user name for session |
| Client OS User |
Client OS user name |
| Logon Time |
Login time |
| Event |
Current wait event, if applicable |
| Wait Time |
if waiting: duration of wait time;
if not waiting: duration of time since session switched between ACTIVE and INACTIVE states (either way) |
| Memory KBytes |
Memory usage, in kilobytes [(session pga memory + session uga memory) / 1024] |
| Since Last Call |
Duration of time since session switched between ACTIVE and INACTIVE states (either way) |
| SQL ID |
SQL ID |
| Child # |
Child # for the SQL; one SQL statement may have multiple child cursors due to environment differences between sessions |