sp406_monitors
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table contains the data associated with the system monitor processes. It includes both the master system monitor and (for a distributed ServiceOptimizer instance) slave system monitors.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| component_no | number | Â |  |
| heartbeat_port | number | Â |  |
| heartbeat_address | varchar2(50) | Â | |
| pid | number | Â | |
| PCI_port | number | Â | |
| PCI_address | varchar2(50) | Â | |
| monitor_state | number | Â | |
Keys
primary key (component_no)Â
foreign key (component_no) references sp400_components (component_no)Â
foreign key (monitor_state) references sp407_monitor_state_decodes (state_no)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| component_no | Component identifier. |
| heartbeat_port | Current port number that the monitor is listening for heartbeats on(Always NULL for a slave system monitor.). |
| heartbeat_address | Address (IP or host name) for the port that the monitor is currently listening for heartbeats on.(Always NULL for a slave system monitor.). |
| pid | Current PID of the monitor (NULL if monitor has exited normally). |
| PCI_port | Current port number that the monitor is listening for Process Control commands on. |
| PCI_address | Address (IP or host name) for the port that the monitor is currently listening for Process Control commands on. |
| osuser | Operating system user that ran the last monitor process (for recovery purposes, this is null if monitor has exited normally). |
| monitor_state | State of the system monitor. |