Parallel DML operations cannot be done on tables with triggers. Documentation too old? Or did I do s
Hi there,
I'm currently learning for my SQL Expert Exams and I stumbled about this answer to a general DML Question:
"Parallel DML operations cannot be done on tables with triggers".
I was a bit stunned, since we basically violate that statement daily. We continuously do parallel DML Statement on our tables whether they have triggers or not.
It never raised an Error and I never even suspected that this could be a problem. So I wrote a simple test and checked, but neither the Explain Plan before nor the AWR after showed a difference
to what I would suspect : a parallel Execution.