Displays or changes DirectConnect for Oracle configuration parameters.
server_name... sp_configure [service_name] [, config_name [, config_value]]
is the name of the DirectConnect 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.
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 DirectConnect 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 parameters, see “Using sp_configure”.
Only the DirectConnect for Oracle administrator can execute sp_configure.
