Will inserts in Serializable transaction freeze the table?
Posted by:
Marc M
Date: March 08, 2009 08:27PM
If I start a serializable transaction, and within that transaction I have an INSERT INTO statement, will all inserts into that table be frozen until this transaction is completed? I do not have a SELECT FOR UPDATE on this table. I want to use a transaction for other queries in this sequence, but if it freezes the table, it could eventually slow down other users. Any tips would be appreciated.
-Marc
------------------------
Inner space - what a trip.
Subject
Views
Written By
Posted
Will inserts in Serializable transaction freeze the table?
3966
March 08, 2009 08:27PM
2187
March 10, 2009 09:22PM
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.