ORA-12801,ORA-04091 With PARALLEL In 18C
(Doc ID 2644293.1)
Last updated on MARCH 01, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : RDBMS version 184.108.40.206.0
DML operation with parallelism is failing with the below error even though there are no trigger(s) present on Schema/Table.
The same insert query runs fine by removing parallel hint.i.e in serial mode it will run fine.
ORA-12801: error signaled in parallel query server P001
ORA-04091: table TEST_TABLE is mutating, trigger/function may not see it
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document