Specifies the nominal threshold size of database connections.
Integer, between 0 and 1000, inclusive
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY SYSTEM OPTION||No||No|
|Allowed to set temporarily?||Yes, with SET ANY SYSTEM OPTION||No||No|
Changing this option takes effect within 5 seconds during the next purge cycle. Any unused database connections having exceeded http_connection_pool_timeout within the http_connection_pool_basesize threshold are deleted. When the size of a connection pool exceeds the http_connection_pool_basesize threshold, connections are deleted at a more aggressive rate.
Specifying a value of 0 purges the HTTP connection pools within 5 seconds of setting the option and disables HTTP connection pooling.
Unused excess connections are removed within half the timeout interval, half of the remainder are purged if unused within a quarter timeout interval, and so on. The following database properties have been added to determine the operating efficiency of the connection pools within a database: