ASA Database Administration Guide
  Database Options
    Alphabetical list of options

WAIT_FOR_COMMIT option [database]

Function 

Determines when foreign key integrity is checked, as data is manipulated.

Allowed values 

ON or OFF

Scope 

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

Default 

OFF

Description 

If this option is set to ON, the database does not check foreign key integrity until the next COMMIT statement. Otherwise, all foreign keys that are not created with the CHECK_ON_COMMIT option are checked as they are inserted, updated or deleted.