Setting Configuration Parameter Values

You can set configuration parameters at three scopes:

  • Database
  • Node
  • Session

Database Scope

You can set one or more parameter values at the database scope with ALTER DATABASE…SET PARAMETER:

ALTER DATABASE dbname SET parameter-name = value[,...];

where dbname can explicitly reference a database by name, or specify DEFAULT to reference the current database.

For example:

ALTER DATABASE DEFAULT SET AnalyzeRowCountInterval = 3600, FailoverToStandbyAfter = '5 minutes';

Node Scope

You can set one or more parameter values at the node scope with ALTER NODE..SET:

ALTER NODE node-name SET parameter-name = value[,...];

For example, to prevent clients from connecting to v_vmart_node0001, set the MaxClientSessions configuration parameter to 0:

=> ALTER NODE v_vmart_node0001 SET MaxClientSessions = 0;

Session Scope

You can set one or more parameter values at the session scope with ALTER SESSION..SET:

ALTER SESSION SET parameter-name = value[,...];

For example:

=> ALTER SESSION SET ForceUDxFencedMode = 1;