The undo tablespace size is more than 5GB and my disk space is filling up fast.
I tried resizing the datafile and it fired with the ORA-03297.
and i guess it affects the performance.
I tried recreating new undo tablespace and assigning that and tried resizing old one. i got the same ORA-03297 error message.
how do we do it??.