Database Tuning (MOSC)

MOSC Banner

Does NOAPPEND hint disable Parallel DML for a MERGE statement?

Question: Does NOAPPEND hint disable Parallel DML for a MERGE statement? Is there a way to NOT move HWM with MERGE and Parallel DML?

*****

When running a very large nightly MERGE statement (inserts Millions of rows and updates millions of rows) I have noticed that when using parallel DML (using hint /* PARALLEL(8) ENABLE_PARALLEL_DML */), the inserts move up the high water mark (which is the default for INSERTS). This is a vendor nonpartitioned hash table, I don't want uncontrolled growth of this table nor rebuild it periodically. See plan below (steps 1 & 2 confirm we are using parallel DML)


Plan hash value: 328507775

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