SQL Language (MOSC)

MOSC Banner

Inserting into a table from a single transaction randomly fails with ORA-08177

in SQL Language (MOSC) 1 commentAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center