16.2 Configuration Reference

Machbase server behavior is controlled by properties in $MACHBASE_HOME/conf/machbase.conf. This section provides a quick reference to each property’s allowed range and default value.

Subsections

Section	Description
Configuration Property Dictionary	Standard Edition properties for server operation, performance, security, and logging
Cluster Configuration Property Dictionary	Cluster Edition properties for Coordinator, Broker, and Warehouse nodes
PVO Cache Property Dictionary	SQL execution plan cache (PVO Statement Cache) properties
Timezone Configuration Dictionary	Timezone properties and client timezone settings

Checking Property Values

Query the v$property system view to check current property values while the server is running.

-- Query all properties
SELECT name, value, type FROM v$property ORDER BY name;

-- Query a specific property
SELECT name, value, min, max
  FROM v$property
 WHERE name = 'PORT_NO';

Dynamically Configurable Properties

Some properties can be changed with ALTER SYSTEM SET without restarting the server.

ALTER SYSTEM SET TRACE_LOG_LEVEL = 3;
ALTER SYSTEM SET PVO_CACHE_MAX_MEMORY_SIZE = 536870912;

Query v$property after a change to verify that it took effect. Attempting to change a property that requires a restart returns an error.

Last updated on Sep 9, 2026