Syntax option:

    LOCK TIMEOUT INTERVAL IS number-seconds SECONDS

    Specifies the number of seconds for processes to wait during a
    lock conflict before timing out. The number of seconds can be
    between 1 and 65,000 seconds.

    Specifying 0 is interpreted as no lock timeout interval being
    set. It is not interpreted as 0 seconds.

    The lock timeout interval is database-wide; it is used as the
    default as well as the upper limit for determining the timeout
    interval. For example, if the database definer specified LOCK
    TIMEOUT INTERVAL IS 25 SECONDS in the CREATE DATABASE statement,
    and a user of that database specified SET TRANSACTION WAIT 30
    or changed the logical name RDM$BIND_LOCK_TIMEOUT_INTERVAL to
    30, SQL uses the interval of 25 seconds. For more information,
    see the SET_TRANSACTION statement and the Oracle Rdb7 Guide to
    Distributed Transactions.