/
sp414_assigned_ports
sp414_assigned_ports
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Analytics
Loading data...
This table is similar to sp409_component_ports. However, no columns are nullable and refer to the actual ports currently in use by the specified component. In particular, if a port is randomly selected, then the actual port used is populated in port_no rather than 0 or null.
Although primarily updated by individual components, system monitor may clear the entries for a component if this component has closed prematurely without tidying up its entries of this table. When system monitor is run with the -c flag, this table will be truncated.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| component_no |  | ||
| port_type | number | | |
| port_no | number |  | |
| port_address | varchar2(50) | | |
| listener_count | number | |
Keys
unique (component_no, port_type)
foreign key (component_no) references sp400_components(component_no)
foreign key (port_type) references sp411_component_port_types(type_no)
Column Descriptions
| Field | Description |
|---|---|
| component_no | Component identifier. |
| port_type | The sort of port this row is to configure. Different options are valid for each type of component. |
| port_no | Port number for the specified port type. |
| port_address | Address (IP or hostname) for the port. |
| listener_count | Number of threads to listen on this port. |
, multiple selections available,
Related content
14.1 sp414_assigned_ports
14.1 sp414_assigned_ports
More like this
sp411_component_port_types
sp411_component_port_types
More like this