MPX_IDLE_CONNECTION_TIMEOUT Option

Time after which an unused connection in the connection pool on a secondary node will be closed.

Allowed Values

0 sec to no limit

Default

600 seconds

Scope

Can be set only for the PUBLIC group. Requires DBA permissions to set the option. Setting takes effect immediately and persists across server restarts.