What does the wait event "blocking txn id for DDL" exactly mean in 11g?
Hi experts,
What does the wait event "blocking txn id for DDL" exactly mean in 11g? Could not find much documentation from KM. Customer is facing this issue in a 11.2.0.2 database where alter table add column hangs on this wait event. The alter table statement never completes and customer has to cancel the session. Tracing the session has not revealed any blockers. The DDL hangs with/without default values for the column being added.
Any pointers in this regard would be much appreciated.
Thanks in advance!
What does the wait event "blocking txn id for DDL" exactly mean in 11g? Could not find much documentation from KM. Customer is facing this issue in a 11.2.0.2 database where alter table add column hangs on this wait event. The alter table statement never completes and customer has to cancel the session. Tracing the session has not revealed any blockers. The DDL hangs with/without default values for the column being added.
Any pointers in this regard would be much appreciated.
Thanks in advance!
Sathish
2