setting the parameter parallel_force_local to false leads to data loss
Date: Mon, 26 Apr 2021 11:45:04 +0200 (CEST)
Message-ID: <1619430304248.1471767.5d83838b7d999d430d8e485820fe8ddea90a633b_at_spica.telekom.de>
Hi all,
does someone has experienced a problem with the parallel_force_local parameter?
In a new created envirement, the database is EE 12.1.0.2.0 64 bit (Redhat), I observed following: In a PL/SQL Block several inserts + commit after each insert are performed. Sometime not all data are commited: Expected inserted rows is 1000. I repeated the test 5 times (each time the table is truncated) and I got this:
- only 127 rows are inserted (the sum of sql%rowcount = 1000)
- 920 rows are inserted (the sum of sql%rowcount = 1000)
- 1000 rows are inserted (the sum of sql%rowcount = 1000)
- 1000 rows are inserted (the sum of sql%rowcount = 1000)
- 1000 rows are inserted (the sum of sql%rowcount = 1000)
In the past I observed the same problem in our production environement (after a migration from AIX to Linux) our regression test had same problem, after each call a different result. My gut feeling I suspected the parallel_force_local parameter that was set to false. After setting the parameter to true everything works as expected (reg test is consistent).
Best regards
Ahmed
--http://www.freelists.org/webpage/oracle-l Received on Mon Apr 26 2021 - 11:45:04 CEST