Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These settings are used by the Platform for the connection towards the Platform database and for ECs for connections towards external databases.

Property

Description

oracle.pool.connectionwaittimeout

Default value: 900

The number of seconds to wait for a free connection if the pool has reached max-connections used.

oracle.pool.inactivitytimeout

Default value: 300

Time (in seconds) to cache an unused connection before closing it.

Note!

The property oracle.pool.minlimit overrides this property and should be set to 0 to ensure that all unused connections are closed.

oracle.pool.maxlimit

Default value: -1

Maximum number of connections in the pool. Should be set to no less than "3". A usual setting would be about 10 to 100.

The default value "-1" means that the number of connections is unlimited.

oracle.pool.minlimit

Default value: 1

Minimum number of connections in the pool.

oracle.pool.propertycheckinterval

Default value: 300

Time (in seconds) to check for unused connections.

oracle.pool.refreshonsqlerror

Default value: false

The Oracle connection pools should refresh all connections in case of an SQL error. If set to "false", no refresh is made.

Oracle Advanced Security Support

...