How to Monitor an Undo Transaction

We can monitor the progress of an undo operation by running the query shown below: From the first session connected as SH we issue a DELETE statement While the delete process is in progress, we can monitor the usage of undo blocks from another session. As user SYS we issue the SQL statement…