|
Specifies the nominal threshold size of database connections.
Integer, between 0 and 1000, inclusive
10
| 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: