sql - Oracle (11.2.0.1) : How to identify the row which is currently updated by the UPDATE statement

Question

My table contains around 1 Billion Records. My UPDATE statement took more time to update the huge volume of records.

Is there any Oracle view to check how many rows are updated currently?

Answer 1

Are you saying you want to monitor the progress of a long-running UPDATE statement? No, I don't know any straightforward way of doing that. No session outside the one running the update statement can see the changes in the table until you commit them.

What you could do is write a PL/SQL program that does it in batches and issues a COMMIT statement in between. That way, a different session could watch the table and see it as pieces of it were updated.