I get sometimes ORA-08177 if I create DB-users parallel and select in SERIALIZABLE transaction

Product: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Hi,

I have the following scenario:

1. I create some new database users parallel and connect them.
2. I insert data in the tables of the newly created users.
3. I start for every newly created user a SERIALIZABLE transaction.
4. I select data from the newly created tables.
5. 
   

Sometimes I get an ORA-08177 error.

It happens only if I create the users parallel.

See the attached shell-script to demonstrate the problem.

You must edit the variables at the beginning of the script and adapt them to your environment.

You can start it with 'sh ora8177.txt syspassword|tee /tmp/out|grep 08177'