Thank you Isotope.
The other reason why I wanted to know which rollback segs are being currently used because I am trying to make scence of my rollback tablespace being 60% occupied. Is the space taken by the rollback seg's currently used? If not, how does my rollback tablespace get filled?
Thank you.