Suppose you have the session a
INSERT/* + APPEND */TABLE_B SELECT/* + PARALLEL */* FROM TABLE_A;
A session b
To INSERT INTO TABLE_A VALUES... Or the update TABLE_A SET statement

Could you tell me whether there are session a jam session b

CodePudding user response:

Won't, undo can ensure A reply data consistency,

CodePudding user response:

reference 1st floor wmxcn2000 response:

no, undo can ensure A reply data consistency,

Please update/* + parallel */TABLE_A where..
Clog
INSERT INTO TABLE_A VALUES...

The update is paralle table level lock