sp_configure

sp_configure displays or changes ECDA Option for Oracle configuration properties.

Syntax

server_name... sp_configure [service_name] [, config_name [, config_value]]

service_name – is the name of the ECDA Option for Oracle service.
config_name – is the name of the configuration parameter to be shown or modified.
config_value – is the value you assign to the configuration parameter.

Example 1 – modifies the connect_string for service DCO_S1.

DCSERVER...sp_configure DCO_S1, connect_string, "ORA817.world"

If no parameters are supplied, sp_configure lists all the services defined:
```
exec DCSERVER...sp_configure
```
sp_configure, with the service_name without a value, lists all of the configuration options for that service.
```
exec DCSERVER...sp_configure, DCSERVER0
```
sp_configure with the service_name (DCSRERVER0), and the option displays 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
```
Note: You cannot use sp_configure to display or edit languages and charsets. 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.
If the config_name parameter is specified, but the config_value parameter is omitted, sp_configure displays the report for the configuration parameter specified.

Only the ECDA Option for Oracle administrator can execute sp_configure.