1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. LOCKTIMEOUT

LOCKTIMEOUT

The LOCKTIMEOUT configuration setting limits the number of seconds a Smart View or other Essbase grid client user can hold an exclusive lock.

LOCKTIMEOUT configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

LOCKTIMEOUT n

where n is the number of seconds. The default value is 3600 seconds (60 minutes).

Description

LOCKTIMEOUT specifies, in seconds, the maximum amount of time a Smart View or other grid client user can hold an exclusive lock on a block. This setting applies to all applications and cubes on the Essbase Server, and is meant to specify a default value for newly created or migrated applications. To override this default for any application, specify a value using the MaxL alter application statement.

Example

LOCKTIMEOUT 300

Commits locked data and releases the exclusive lock after the lock has been held for 300 seconds (five minutes).