Recommended database setting

Setting appropriate values for the database parameters based on the actual needs can reduce the occurrence of database deadlock and block hence can improve the concurrency and stability of the Web application.

Command Timeout

Specify the timeout period for the commands. In the following table, it shows how to set Command Timeout to 120 seconds in different databases.

Table 4. Command timeout settings in different databases

Database Type

Parameter

Remark

SAP SQL Anywhere

BLOCKING_TIMEOUT

Execute the following command:

SET OPTION Public.BLOCKING_TIMEOUT = 120000

ASE

lock wait period

Execute the following command:

sp_configure "lock wait period", 120

SQL Server

-

Modify the Command Timeout parameter in Edit Data Source page of AEM.

Command Timeout = 120

Oracle

IDLE_TIME

Execute the following command:

ALTER PROFILE default LIMIT IDLE_TIME 2;

Informix

DEADLOCK_TIMEOUT

Modify the DEADLOCK_TIMEOUT parameter in ONCONFIG.std file.

DEADLOCK_TIMEOUT = 120

Teradata

-

Modify the Command Timeout parameter in Edit Data Source page of AEM.

Command Timeout = 120