Hi,
i've read that: “Starting with 12c, we allow parallel INSERTs into non-partitioned tables with LOB columns provided that those columns are declared as SecureFiles LOBs”
But it doesn't works for me.
My database is a 12.1.0.2.19 and when try to perform this insert:
insert /*+ parallel enable_parallel_dml */ into MY_BLOB select /*+ parallel */ * from MY_BLOB_OLD;
many parallel session goes to ENQ TX - Row lock contention.
The lob is in Securefile.
So what's wrong?
Thank you