Inserting into a table from a single transaction randomly fails with ORA-08177
Hi,
I am randomly getting ORA-08177: can't serialize access for this transaction
errors even when there is only one active session.
I am using the following Oracle Database version (BANNER_FULL
from GV$VERSION
):
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
To reproduce the problem, I created the following objects, specifying SEGMENT CREATION IMMEDIATE
to avoid the problem described in Oracle Support Document 1285464.1 (ORA-08177: Can't Serialize Access For This Transaction After Upgrading To 11.2):
create table bug_ora08177_tab ( id number(19,0) not null primary key, name varchar2(100) not null unique ) segment creation immediate; create sequence bug_ora08177_seq order;