Versions Compared

Key

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

...

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

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

...

More information about Oracle Advanced Security can be found in the Oracle Database Advanced Security Administrator's Guide.

Note

Note!

only supports Oracle Advanced Security for Oracle 12.2.

...