Enable connection blocking to force any transaction attempting to obtain a lock that conflicts with another transaction's existing lock to wait: either until every conflicting lock is released, or until the BLOCKING_TIMEOUT threshold is reached.
set temporary option blocking = 'On';