If we have a table which is accessed by multiple users and two or more user's are simultaniously trying to modify the table. Then what happens and how can we manage such situations?

Questions by techmind

Showing Answers 1 - 8 of 8 Answers

praveen

  • Dec 7th, 2006
 

if one user is going to modify the table he will be aquired lock on that particular row of that table and it will be released to the other user whose is trying ot modify the same table after the modifications are commited by the first user. or else, we can handle the situations using no wait option

  Was this answer useful?  Yes

techmind

  • Dec 7th, 2006
 

Could you please elaborate how can we do it with no wait option.

  Was this answer useful?  Yes

Gajanan

  • Jul 13th, 2007
 

There are two ways of changing the rows in particular table.
One to delete the row
Second to modify/Change the data of row in table.
In every case we opt for exclusive locks

So when one user has exclusive lock then another user can’t share that information unless first user releases that locks.

Another type of lock is shared lock, which is used when two or more users share the same information for reading purpose (No change in the database).


dj_dj_dj

  • Mar 18th, 2010
 

Simultaneously modification of same table by two or more users cause Oracle server to go into hang state, to avoid such a state first user who used dml statement should issue commit or rollback comand.

Possible solutions also consist of that the Oracle DBA could create procedure which states ''''' for update of column_name nowait ''' command.

Regards
Dharmendra Jaiswal

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions