DDL_LOCK_TIMEOUT
DDL_LOCK_TIMEOUT specifies a time limit for how long DDL statements will wait in a DML lock queue.
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 0 |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Modifiable in a PDB | Yes |
| Range of values | 0 to 1,000,000 (in seconds) |
| Basic | No |
A value of zero indicates a status of NOWAIT. The maximum value of 1,000,000 seconds will result in the DDL statement waiting forever to acquire a DML lock.
If a lock is not acquired before the timeout period expires, then an error is returned.
See Also:
-
Oracle AI Database Administrator’s Guide for more information about the
DDL_LOCK_TIMEOUTparameter -
Oracle AI Database Development Guide for information about nonblocking and blocking DDL