Page tree
Skip to end of metadata
Go to start of metadata

Sets a value of a parameter. 


SET [SESSION|GLOBAL] parameter-name=value;


The value can be set at either the session or the global level. 

Setting at session level is valid only during the current session's lifetime; setting at global level is persistent and affects the entire system by becoming the default value for all new sessions. 
If set level is not specified, session level is assumed. 

Hierarchy of the parameters value levels (top override lower levels):

  1. Session level setting
  2. Local setting (through the local-conf.ini file)
  3. Global level setting
  4. Default value

To reset a parameter to its default value, use the UNSET command.


set adaptive.cache.query.enable=1;
set global; 

See Also


  • No labels