Contents Index BLOCKING option [database] CHAINED option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

BLOCKING_TIMEOUT option [database]


Function 

To control how long a transaction waits to obtain a lock.

Allowed values 

Integer, in milliseconds

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Default 

0

See also 

BLOCKING option [database]

Description 

When BLOCKING is ON, any transaction attempting to obtain a lock that conflicts with an existing lock waits for BLOCKING_TIMEOUT milliseconds for the conflicting lock to be released. If the lock is not released within BLOCKING_TIMEOUT milliseconds, then an error is returned for the waiting transaction.

Setting this option to 0 forces all transactions attempting to obtain a lock to wait until all conflicting transactions release their locks.


Contents Index BLOCKING option [database] CHAINED option [compatibility]