What are DDL locks?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are DDL locks?
Rating:
DDL locks are used on segments while performing DDL operations (CREATE, ALTER, and DROP) on them. These locks prevent the definition of a segment from being modified by two separate processes simultaneously. Unlike the DML locks, these locks are obtained only at the table level.
Rating:
Was this information helpful?
Other articles
- What is Environment class?
- What is an optimizer ?
- What is System Monitor (SMON)?
- What is the REBUILD option of the ALTER INDEX statement?
- What are the steps involved in performance tuning?
