Skip to content

Database Tuning (MOSC)

MOSC Banner

Does NOAPPEND hint disable Parallel DML for a MERGE statement?

in Database Tuning (MOSC) 3 commentsAnswered

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

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center