Database Administration (MOSC)

MOSC Banner

oracle table update question

edited Apr 6, 2010 1:34AM in Database Administration (MOSC) 3 commentsAnswered
 our customer have some question about update to ask!

1. a table have 5million rows , they want to update 500 thousand rows , so it will have row lock,

they want to know if there will have 500 thousand  row lock ( one row lock  per one row), or

just one row lock  ( one lock per 500 thousand rows  ), they want to kown oracle lock mechnisam.

suggeust just  update two row , how oracle hand it , first lock one row, then the same lock  lock the second

row, commit, the lock will release , is that  explain right  ?

2.how is update ( update  numbers  of row )  or the lock  effect to db , can cause oracle problem,can oracle hang!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center