Search code examples
transactionsconcurrencyoracle10g

Can two transaction run at same time in Oracle?

I have a method 

void SaveApplicationData()
{
   begin transaction
   update
   insert
   commit transaction
}

if two users call this method at same time, can these two database transaction run at same time?

Solution

  • Large numbers of transactions can be running simultaneously. However, if they're updating the same rows, they may well have locking problems, and one or more may be rolled back. (It's a long time since I dealt with conflicting transactions.)