Displays or changes ECDA Option for Oracle configuration properties.
server_name... sp_configure [service_name] [, config_name [, config_value]]
is the name of the ECDA Option for Oracle service.
is the name of the configuration parameter to be displayed or modified.
is the value you assign to the configuration parameter.
DCSERVER...sp_configure DCO_S1, connect_string, "ORA817.world"
Modifies the connect_string for service DCO_S1.
If no parameters are supplied, sp_configure will list all the services defined:
exec DCSERVER...sp_configure
sp_configure, with the service_name without a value, will list all of the configuration options for that service.
exec DCSERVER...sp_configure, DCSERVER0
sp_configure with the service_name (DCSRERVER0), and the option will display the current value of the option:
exec DCSERVER...sp_configure, DCSERVER0, max_users
If a value is supplied, such as “100” in the following example, sp_configure changes the option:
exec DCSERVER...sp_configure, DCSERVER0, max_users, 100
Languages and charsets cannot be displayed or edited
with sp_configure. To change these properties,
the configuration file must be edited manually.
When you execute sp_configure to modify a dynamic parameter:
The configuration and run values are updated.
The configuration file is updated.
The change takes effect immediately for all new connections. Current connections are unchanged.
When you execute sp_configure to modify a static parameter:
The configuration value is updated.
The configuration file is updated.
The change takes effect only when you restart ECDA Option for Oracle.
When issued with no parameters, sp_configure displays all the service names.
When issued with only the service_name parameter, sp_configure displays all the configuration information for the service.
If the config_name parameter is specified, but the config_value parameter is omitted, sp_configure displays the report for the configuration parameter specified.
For information on the individual configuration properties, see “Using the command line”.
Only the ECDA Option for Oracle administrator can execute sp_configure.
