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?
See Question&Answers more detail:osMy 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?
See Question&Answers more detail:osAre 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.