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.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…