Transaction in the undo tablespace
The application is incredibly slow and is not allowing the users to commit any transactions The reason to this is that my undo tablespace has been at 100% for a couple of hours now. Earlier today one of the developers had run a huge delete statement which might have caused this scenario. I had to kill his process cause the archive log destination filled up.
What query could I run to see which are the transactions in the undo tablespace and also what could I do to get the that cleared out faster without adding more space to the undo tablespace?
Would a bounce to the database solve this issue (this would be my last alternative).
Your input would be greatly appreciated.
DBA01