Precedence of Automatic Degree of Parallelism in 11g2

Hello,

We recently faced the ORA-12838 error (Cannot read/modify an object after a parallel modification on it in the same transaction) on a batch job after enabling Automatic Degree of Parallelism.

We have narrowed down the problem to a DELETE statement followed by a SELECT statement on the same table:

- DELETE MYTABLE WHERE ....--> OK

- SELECT * FROM MYTABLE --> KO

The DELETE runs fine but the following SELECT on the table that has just been deleted raises the ORA-12838 error.

Now, the strange thing is that the DOP on the table is 1, and no PARALLEL hint was used for the DELETE statement.