How to monitor the progress of an UNDO operation
We can monitor the progress of an undo operation by running the query shown below: select ses.username , substr(ses.program, 1, 19) command , tra.used_ublk , from v$session ses , v$transaction tra where ses.saddr = tra.ses_addr; From the first session connected as SH we issue a DELETE statement SQL> conn sh/sh Connected. SQL> delete sales; While […]