Engines
(INSTANCEID, ENGINENUMBER)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| ENGINENUMBER | long | Engine ID |
| CPUTIME | long | CPU time of engine, in seconds; System CPU + User CPU + I/O CPU (process kernel) + Idle CPU |
| SYSTEMCPUTIME | long | System CPU time of engine, in seconds |
| USERCPUTIME | long | User CPU time of engine, in seconds |
| IOCPUTIME | long | I/O CPU time of engine, in seconds; for threaded kernel, always 0 |
| IDLECPUTIME | long | Idle CPU time of engine, in seconds |
| CONTEXTSWITCHES | long | Number of context switches |
| CONNECTIONS | long | Number of connections on the engine |
| PROCESSESAFFINITIED | long | Number of processes affinitied to the engine |
| STATUS | string(24) | Status of the engine (online, offline, etc.) |
| AFFINITIEDTOCPU | long | ID of CPU to which the engine is affinitied to |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| CPU_DELTA | double | Delta CPU time of engine, in seconds |
| CPU_RATE | double | CPU %, in interval |
| CPU_RATE_OVR | double | Average CPU %, since collection started |
| CPU_OVERALL | double | Total CPU time of engine, in seconds, since collection started |
| SYSTEMCPU_DELTA | double | Delta System CPU time of engine, in seconds |
| SYSTEMCPU_RATE | double | System CPU %, in interval |
| SYSTEMCPU_RATE_OVR | double | Average System CPU %, since collection started |
| SYSTEMCPU_OVERALL | double | Total System CPU time of engine, in seconds, since collection started |
| USERCPU_DELTA | double | Delta User CPU time of engine, in seconds |
| USERCPU_RATE | double | User CPU %, in interval |
| USERCPU_RATE_OVR | double | Average User CPU %, since collection started |
| USERCPU_OVERALL | double | Total User CPU time of engine, in seconds, since collection started |
| IOCPU_DELTA | double | Delta I/O CPU time of engine, in seconds; for threaded kernel, always 0 |
| IOCPU_RATE | double | I/O CPU %, in interval; for threaded kernel, always 0 |
| IOCPU_RATE_OVR | double | Average CPU %; for threaded kernel, always 0 |
| IOCPU_OVERALL | double | Total I/O CPU time of engine, in seconds, since collection started; for threaded kernel, always 0 |
| IDLECPU_DELTA | double | Delta Idle CPU time of engine, in seconds |
| IDLECPU_RATE | double | Idle CPU %, in interval |
| IDLECPU_RATE_OVR | double | Average Idle CPU %, since collection started |
| IDLECPU_OVERALL | double | Total Idle CPU time of engine, in seconds, since collection started |
| CONTEXTSWITCHES_DELTA | double | Delta number of context switches |
| CONTEXTSWITCHES_RATE | double | Number of context switches per second, in interval |
| CONTEXTSWITCHES_RATE_OVR | double | Average number of context switches per second, since collection started |
| CONTEXTSWITCHES_RATE_MAX | double | Maximum number of context switches per second, since collection started |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |