Re: Concurrent INSERT/DELETE
Posted by:
Rick James
Date: April 25, 2013 09:09AM
Is there a row where id=2?
What else is in each transaction?
Why is the insert transaction running so long that it can trip up the delete?
What setting of autocommit do you use?
Do you use BEGIN...COMMIT?
Subject
Views
Written By
Posted
3821
April 24, 2013 03:56AM
Re: Concurrent INSERT/DELETE
1262
April 25, 2013 09:09AM
1254
April 29, 2013 09:02AM
1200
April 30, 2013 07:57AM
1019
May 03, 2013 03:34AM
1012
May 03, 2013 01:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.