Oracle database in the delete one table data have been execution status, not an error
Every time expressions under the words of the lock, delete produces two locks

How to solve it

CodePudding user response:

Delete delete already produce lock, you can't delete may be due to the large amount of data, deleting slowly,
It is possible that produces a deadlock (another transaction produced a lock on the table, cause you've been waiting for the delete)

CodePudding user response:

Data volume is 200 w, but performed for 24 hours or are performing
I perform
Select p. pid, a.s erial#, c.o bject_name, b.s ession_id, b.o racle_username, b.o s_user_name from v $process p, v $session a, b v $locked_object, all_objects c where p.a DDR=Amy polumbo addr and Amy polumbo rocess=p. rocess and c.o bject_id=b.o bject_id;
Result is only I delete statement produced lock

CodePudding user response:

Partial deletion, 10000 lines each time, run a cycle,

CodePudding user response:

This is a large amount of data, you can take up the delete rollback segments, partial deletion, commit to submit, after each delete execution cycles