Versions Compared

Key

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

...

Note!

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

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

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.

...

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

Note

Note!

This version of Usage Engine only supports Oracle Advanced Security for Oracle 12.2.

Property

Description

oracle.net.encryption_client

The level of security of the client that will connect to the Oracle database is determined with this parameter. Accepted values include, REJECTED, ACCEPTED, REQUESTED and REQUIRED.

Info

Example

oracle.net.encryption_client="REQUIRED"

oracle.net.encryption_types_client

The encryption algorithm to be used is determined with this parameter.

oracle.net.crypto_checksum_client

The level of security when it comes to data integrity for the connection with the Oracle database is determined with this parameter. Accepted values include, REJECTED, ACCEPTED, REQUESTED and REQUIRED.

Info

Example

oracle.net.crypto_checksum_client="REQUIRED"

oracle.net.crypto_checksum_types_client

The data integrity algorithm to be used is determined with this parameter.

...