ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ISOLATION_LEVEL option [compatibility]

Function 

Controls the locking isolation level.

Allowed values 

0, 1, 2, or 3

Scope 

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

Default 

0

1 for Open Client and JDBC connections

Description 

This option controls the locking isolation level as follows.

• 0    Allow dirty reads, non-repeatable reads, and phantom rows.

• 1    Prevent dirty reads. Allow non-repeatable reads and phantom rows.

• 2    Prevent dirty reads and guarantee repeatable reads. Allow phantom rows.

• 3    Serializable. Do not allow dirty reads, guarantee repeatable reads, and do not allow phantom rows.

For more information, see Isolation levels and consistency.