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
--------- ------------------------------------------------------------------