5 locked per table and of course there was no parallel dml. But if a single
session did a mathematical update to a number, say, modulo or so forth, so
that unique violations took place, then the commit would fail. Likewise
trying to swallow a batch twice so that duplicates accrued, which we used to
protect ourselves at "Coat" in case our mail batch forward service re-sent a
batch due to uncertainty regarding the delivery. Nice safety net, but we
tried to avoid it because minimizing i/o to the before image and after image
files were part of avoiding having to do a recovery. And with table lock
granularity, if you did a big "rollback" everyone waited.
I'm not sure I tested anything like this in 3 or 4 and we didn't rely on
Oracle to catch more than clean, correct transactions. (We weren't expecting
it to be solid like COBOL yet.)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jonathan Lewis
Sent: Sunday, July 23, 2017 6:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle to Postgres training at PGConf US
If only Franck had Oracle 5 for his test - I think that's the version that
last had that bulk update/unique colission problem (but maybe it was Oracle
4).
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Stefan Koehler <contact@xxxxxxxx>
Sent: 23 July 2017 07:59
To: oracle-l@xxxxxxxxxxxxx; jd@xxxxxxxxxxxxxxxxx
Subject: Re: Oracle to Postgres training at PGConf US
Hey JD,
to get back on a technical track and ignore all other on-going personal
things here :-)
What do you think about this?
https://twitter.com/FranckPachot/status/888867529954820097
This looks crazy to me (and possibly all other Oracle folks out there).
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> hat am 21. Juli 2017 um 18:01geschrieben:
--
Meanwhile, PGConf US Seattle is selling at record pace and we would
love to see a lot of Oracle people there! We want to help you where
you think Postgres could fit.
Have a great weekend!
JD