Host Processes
Process metrics collected at the host every 60 seconds.
Table 17-22 Host Processes
| Field Name | Name | Column Type | Column Category | Description |
|---|---|---|---|---|
| ROLLUP_TIME_UTC | Rollup time (UTC) | TIMESTAMP | TIME_DIMENSION | End timestamp of the rollup period (UTC) |
| START_TIME_UTC | Start time (UTC) | TIMESTAMP | DIMENSION | Timestamp when the command started (UTC) |
| DAY_OF_WEEK | Collection day of week | VARCHAR2 | DIMENSION | Collection day in weekly range 1-7 (Mon-Sun) |
| DAY_OF_MONTH | Collection day of month | VARCHAR2 | DIMENSION | Collection day in monthly range 1-31 |
| HOUR_OF_DAY | Collection hour of day | VARCHAR2 | DIMENSION | Collection hour in hourly range 0-23 |
| OPSI_ID | Database insight OCID | VARCHAR2 | DIMENSION | Database insight resource OCI |
| HOST_NAME | Host Name | VARCHAR2 | DIMENSION | Name of the host |
| HOST_DISPLAY_NAME | Host display name | VARCHAR2 | DIMENSION | Display name of the host |
| HOST_TYPE | Host type | VARCHAR2 | DIMENSION | Type of the host |
| ENTITY_SOURCE | Telemetry source entity identifier | VARCHAR2 | DIMENSION | Host insight telemetry identifier |
| PLATFORM_TYPE | Platform type | VARCHAR2 | DIMENSION | Type of platform currently running on the host |
| PLATFORM_NAME | Platform name | VARCHAR2 | DIMENSION | Name of the platform currently running on the host |
| PLATFORM_VERSION | Platform version | VARCHAR2 | DIMENSION | Version of the platform currently running on the host |
| CPU_ARCHITECTURE | CPU architecture | VARCHAR2 | DIMENSION | Conceptual design and operational structure of the CPU used by the host |
| VENDOR | Vendor | VARCHAR2 | DIMENSION | Provider that distributes the host |
| CPUS_ALLOCATED | CPUs allocated | NUMBER | METRIC | Total number of CPUs on the system |
| MEMORY_ALLOCATED | Host allocated memory (GB) | NUMBER | METRIC | Total amount of usable physical RAM available to the host |
| ASSOCIATED_RESOURCE_ID | Associated resource identifier | VARCHAR2 | DIMENSION | Associated resource identifier |
| SOURCE_IDENTIFIER | Telemetry source identifier | VARCHAR2 | DIMENSION | Enterprise Manager GUID or Management Agent OCID (identifier for where the telemetry is being collected) |
| SOURCE_ENTITY_IDENTIFIER | Telemetry source entity identifier | VARCHAR2 | DIMENSION | Enterprise Manager target GUID for the cell |
| USER_NAME | Username | VARCHAR2 | DIMENSION | Username that executed the command |
| PID | OS process identifier | NUMBER | METRIC | The identifier by the process |
| COMMAND | Command | VARCHAR2 | DIMENSION | Program, instruction, or utility running in the host |
| PHASH | Command line identifier | VARCHAR2 | DIMENSION | Hash created for the command line as a unique identifier |
| CPU_USAGE | CPU usage | NUMBER | METRIC | Total CPUs used in the process at the time of collection |
| CPU_UTIL | CPU utilization (%) | NUMBER | METRIC | Percentage of total CPU time spent across all CPUs |
| MEMORY_UTIL | Memory utilization (%) | NUMBER | METRIC | Percentage of memory used |
| VIRTUAL_MEM | Virtual memory used (MB) | NUMBER | METRIC | Virtual memory (in megabytes) used by the process |
| PHYSICAL_MEM | Physical memory used (MB) | NUMBER | METRIC | Physical memory (in megabytes) used by the process |
| PROCESSES_COUNT | Total processes | NUMBER | METRIC | Total number of processes that ran the host at the time of collection |
| PROCESS_ALIAS | VARCHAR2 | DIMENSION | METRIC | Friendly alias for known process to be used instead of full command line |