79289062

Date: 2024-12-17 18:59:04
Score: 1
Natty:
Report link

Is it any table which you can't interact with or just that particular one?

If it's a large table and you left the update running for a long time and then killed your session, there may be a delay before the Oracle smon process kicks in and gets the changes rolled back. In the meantime there may be losts of locked rows. Any attempted updates to such rows, will appear to hang (they are just queuing, waiting for locks to be released).

Reasons:
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): Is it any
  • Low reputation (0.5):
Posted by: avalon20