Глоссарий терминов Oracle
share DDL lock
Перевод разделяемая блокировка DDL
Описание E.g., when a CREATE PROCEDURE statement is executed, the containing transaction acquires ~ for all referenced tables. Other transactions can concurrently create procedures that reference the same tables and therefore acquire concurrent share DDL locks on the same tables, but no transaction can acquire an exclusive DDL lock on any referenced table. No transaction can alter or drop a referenced table. As a result, definition of the referenced schema object will remain constant for the duration of the transaction.