Consult everybody, I'm in Oracle is used when the insert append at the same time, also want to add parallelism and noggloging, this syntax should be how to write a little, right is the insert/* + append, the parallel (TMP, 8) nologging */into/* + append or insert the parallel (TMP, 8) nologging */into/* + append, or insert the parallel (TMP, 8), nologging */into, I'm struggling with the use of the comma and the order of the three parameters, the local is not good, you have any practical experience or more correct wording, thank you for the first

CodePudding user response:

Written in the following two,

The alter table TMP nologging;

Insert/* + append the parallel (TMP, 8) */into

CodePudding user response:

reference 1st floor selling fruit net reply:

written in the following two article,

The alter table TMP nologging;

Insert/* + append the parallel (TMP, 8) */into

The/* + append the parallel (TMP, 8) */the append and parallel with ', '(comma
)?

CodePudding user response:

Don't have to add a comma, by a space,

CodePudding user response:

reference 3 floor selling fruit net reply:

don't have to add a comma, a space,

Ok, thanks, I try

CodePudding user response:

Insert/* 8 + parallel nologging */
No comma, parallel automatically append mode after loading (will lock table, cautious)
In the session, to open a parallel allows, alter session enable parallel DML;

CodePudding user response:

1, nologging is the key word, was never a hint;
2, add after append, other DML session will be in waiting tables;
3, if want to use good parallel SQL: pay attention to the good system resource usage; If you want to parallel DML, explicitly open parallel DML; The insert statement and select statement best parallelism

CodePudding user response:

reference learning turn _ 5 floor response:

insert/* 8 + parallel nologging */
No comma, parallel automatically append mode after loading (will lock table, cautious)
In the session, to open a parallel allows, alter session enable parallel DML;

Alter session enable the parallel dm;
The alter table TMP nologging;

Insert/* + append the parallel (TMP, 8) */into/TMP the select * + parallel (b, 8) */* from b;
So I wrote words will have a problem

CodePudding user response:

refer to 6th floor minsic78 response:

1, nologging is the key word, was never a hint;
2, add after append, other DML session will be in waiting tables;
3, if want to use good parallel SQL: pay attention to the good system resource usage; If you want to parallel DML, explicitly open parallel DML; Insert statement and select statement best option as the parallelism of

Alter session enable the parallel dm;
The alter table TMP nologging;

Insert/* + append the parallel (TMP, 8) */into/TMP the select * + parallel (b, 8) */* from b;
Then I can write words, if you have any questions

CodePudding user response:

refer to 7th floor panda0234 response:

Quote: reference to learning turn _ 5 floor response:

Insert/* 8 + parallel nologging */
No comma, parallel automatically append mode after loading (will lock table, cautious)
In the session, to open a parallel allows, alter session enable parallel DML;

Alter session enable the parallel dm;
The alter table TMP nologging;

Insert/* + append the parallel (TMP, 8) */into/TMP the select * + parallel (b, 8) */* from b;
Is there any problem that I write words will

Yes, append can not add, add in parallel is used in the default load append mode