Hi All,
A delete statement to delete millions of records from a table was in progress and application team killed the process as it was exectuing for.
more than 10 hrs. After killing the process, the table is locked as the roll back is still in progress. For roll back to get completed, it will take another 10 hrs.
Is there a better way to release the lock from the table?
SQL> select used_ublk,used_urec from v$transaction;
USED_UBLK USED_UREC
---------- ----------
45360 1898141
2 210
SQL> select used_ublk,used_urec from v$transaction;
USED_UBLK USED_UREC
---------- ----------
45302 1895407
DB Version:11.2.0.2
OS :linux 64 bit