Undo Segments : Drop Problematic Undo Segments
ERROR about to recover undo segment 98 status:6 inst:0 mark undo segment 98 as available status:6 ret:1 about to recover undo segment 46 status:6 inst:0 mark undo segment 46 as available status:6 ret:1 SQL> select * from V$FAST_START_TRANSACTIONS; USN SLT SEQ STATE UNDOBLOCKSDONE UNDOBLOCKSTOTAL PID CPUTIME PARENTUSN PARENTSLT PARENTSEQ XID PXID RCVSERVERS CON_ID ---------- ---------- ---------- ---------------- -------------- --------------- ---------- ---------- ---------- ---------- 46 46 2313064 RECOVERING 505 24992423 77 5586 0 0 0 10001000684B2300 0000000000000000 1 0 98 25 1352150 RECOVERING 0 226231 78 5586 0 0 0 30001900D6A11400 0000000000000000 1 0 SQL> SELECT segment_name, tablespace_name FROM dba_rollback_segs WHERE segment_id IN (98, 46); SEGMENT_NAME TABLESPACE_NAME ------------------------------ ----------------------------...