Execute the SQL is: the update yj_yyrg set ishandle='2', user='ss', the username='yangzh', the date='20190826', time='114332' type='2', id='F201908260005' where model_id=120 and row_id=40, can quickly perform in a test environment in the past, can open the page, change an environment not, page has been card, had a this kind of situation, before colleagues to execute the alter table move solved, this time is not line, who is a great god to look at, very grateful!

CodePudding user response:

This statement is very simple, only consider an increase in the index, model_id and row_id composite index,

CodePudding user response:

This statement you want to update the amount of data that stable instability? Will the data change possible? If not, then may be encountered lock waits, check the v $session inside the update session a few field values: event, blocking_instance, blocking_session, is under the blocking_instance blocking_session will be blocked, you look at the lock is held, blocking your session in the stem, the kill was killed

CodePudding user response:

refer to the second floor minsic78 response:

this statement you want to update the amount of data that stable instability? Will the data change possible? If not, then may be encountered lock waits, check the v $session inside the update session a few field values: event, blocking_instance, blocking_session, is under the blocking_instance blocking_session will be blocked, you look at the lock is held, blocking your session in the stem, the kill it kill

Amount of data in one thousand or so a day, the background this article no lock table, will be related to the table space?

CodePudding user response:

is the name of the reference 3 floor wang sauce meow sauce response:

Quote: refer to the second floor minsic78 response:

this statement you want to update the amount of data that stability is not stable? Will the data change possible? If not, then may be encountered lock waits, check the v $session inside the update session a few field values: event, blocking_instance, blocking_session, is under the blocking_instance blocking_session will be blocked, you look at the lock is held, blocking your session in the stem, the kill it kill

Amount of data in one thousand or so a day, the background this article no lock table, will be related to the table space?

You mean, this update statement executed once, at a time will update 1000 records?
To accept this update first take a look at the execution of the plan