Internal JOIN collection used by LOGINS collection; summary statistics for logins
This is an internal collection which is used to produce the LOGINS collection. Please use the LOGINS collection, instead.
(SUID)
| Name | Data Type | Description |
|---|---|---|
| SUID | long | Server user ID |
| LOGIN_COUNTS | long | Number of current processes (connections) with the login, excluding system processes |
| CPUTICKS | long | Total CPU ticks of current processes with the login, excluding system processes |
| CPUSECS | long | Total CPU time of current processes with the login, excluding system processes, in seconds |
| PHYSICAL_IO | long | Total physical I/Os of current processes with the login, excluding system processes |
| MEMUSAGE | long | Total memory usage of current processes with the login, excluding system processes, in bytes |
| BLKBY | long | Largest SPID # of all processes blocking current processes with the login, excluding system processes |
| MERGESTATUS | long | Internal-use column merge status; created by Surveillance |
| CPUPCT | double | Total CPU % Used (1 CPU) of current processes with the login, excluding system processes, in interval |
| CPUPCT_AVG | double | Average total CPU % Used (1 CPU) of current processes with the login, excluding system processes, since collection started |
| CPUPCT_MAX | double | Maximum total CPU % Used (1 CPU) of current processes with the login, excluding system processes, since collection started |
| PHYSICAL_IO_RATE | double | Total physical I/Os per second of current processes with the login, excluding system processes, in interval |
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |