sp213_scheduler_parameters

This table specifies values of scheduler parameters for each responsibility unit (together with any other non-scheduler related parameters which nevertheless vary by responsibility unit).

Table Definition

Field	Type	Default	Nullable
resp_unit_no	number(4)
parameter_set	number(2)
name	varchar2(30)
value	varchar2(1024)

Keys

primary key (resp_unit_no, parameter_set, name)
foreign key (resp_unit_no) references sp058_responsibility_units (resp_unit_no)
foreign key (name) references sp083_system_parameters (name)

Column Descriptions

Field	Description
resp_unit_no	An internal number identifying the responsibility unit.
parameter_set	Used to allow multiple sets of parameters to be defined. Currently, the permitted values are: 0 – not used 1 – general/optimizer parameters
name	Parameter name: a definition of a parameter of this name must exist in sp083_system_parameters.
value	Parameter value, held as a string. It is the responsibility of each application to convert this value to the required type, as indicated in sp083_system_parameters.