Aborted session will remain in aborting state until rollback is completed.Run this command in rcvmanager utility: > LIST ROLLBACK TABLES;
Example: # cnsterm 6 Attempting to connect to CNS...Completed. Hello > start rcvmanager start rcvmanager Started 'rcvmanager' in window 1 at Thu Jan 16 08:57:30 2020 Input Supervisor Command: > ^C # cnsterm 1 Attempting to connect to CNS...Completed. Hello (A Large Cylinder is 6 times the size of a small cylinder) Ferret ==> quit Waiting for Ferret Slave Tasks to exit Ferret Exited _______ | | | | ___ __ ____ | ____ __|__ ____ | / |/ \ ____| ____| ____| | ____| | --- | / | / | / | | / | | \___ | \____| \____| \____| |__ \____| Release 16.20.32.11 Version 16.20.32.11 RCVMANAGER Utility (Jan 96) Enter command, "QUIT;" or "HELP;" :> list rollback tables; list rollback tables; TABLES BEING ROLLED BACK AT 09:00:02 20/01/16 ONLINE USER ROLLBACK TABLE LIST Host Session User ID Performance Group AMP W/Count ---- -------- --------- ------------------------------ ----------- TJ Rows Left TJ Rows Done Time Est. ------------- ------------- --------- Table ID Name --------- ------------------------------------------------------------------ SYSTEM RECOVERY ROLLBACK TABLE LIST Host Session TJ Row Count ---- -------- ------------- Table ID Name --------- ------------------------------------------------------------------ |