Database Behavior | ABORT | IMMEDIATE | TRANSACTIONAL | NORMAL |
Permits new user connections | No | No | No | No |
Waits until current sessions end | No | No | No | Yes |
Waits until current transactions end | No | No | Yes | Yes |
Performs a checkpoint and closes open files | No | Yes | Yes | Yes |