DDL_WAIT_FOR

DDL_WAIT_FOR_LOCKS

Property	Description
Parameter type	Boolean
Default value	`false`
Modifiable	`ALTER SESSION`, `ALTER SYSTEM`
Range of values	`true \| false`
Basic	No

DDL_WAIT_FOR_LOCKS specifies whether DDL statements (such as ALTER TABLE ... ADD COLUMN) wait and complete instead of timing out if the statement is not able to acquire all required locks.

Values:

true

DDL statements wait until the statement acquires all required locks
false

DDL statements time out if the statement cannot obtain all required locks