SQL Language (MOSC)

MOSC Banner

Parallel DML operations cannot be done on tables with triggers. Documentation too old? Or did I do s

edited May 1, 2015 10:03AM in SQL Language (MOSC) 3 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center