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 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 and the upper limit when determining the timeout
    interval. For example, if the database definer specified LOCK
    TIMEOUT INTERVAL IS 25 SECONDS in the ALTER 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 still uses the interval 25. For more information on timeout
    intervals, see the Oracle Rdb7 Guide to Distributed Transactions.