|
-
NOTE: Following exists before executing INSERT..SELECT
* Parallel DML is enabled.
* The table being inserted has Parallel degree pre-defined and/or the SELECT SQL has suppied with PARALLEL hints and/or the table being queried has Parallel degree pre-defined.
* Enough PQ Servers are available/running.
* Hardware supports Parallel DML.
* Instance has been started with enough various memory pockets.
Apart from above , it has to be multi cpu box if that iswhat u mean by Hardware.
Parallel load anyway does a direct load and is above HWM of table.
The append hint just pushes the insert above the HWM of table.
So u did not need to give both hints together.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|