Can anybody help me on "what all users are using the undo tablespace and how much" in oracle database 11g r2. any pointers would be much appreciated.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
This shows you the amount of undo size used by each session that is currently active.
Undo is not used by users directly but by statements which modify many database blocks. Try to search for session which generates a lot of redo.
Or for active transactions:
Or look at the view V$UNDOSTAT.