Hi experts, I just killed a very long session which wasn't responding and was inactive for 2 days. The session was performing a delete operation on a table. After I killed the session, I noticed that the size of one rollback segment became very large, the optimal value is 4M and the current size of the particular rollback segment is 500M. I have tried to shrink rollback segment manually like this alter rollback segment rbs25 shrink to 4M; but in vain. what should I do? how could it be known that a particular rollback segment is using currently which transactions? Thanks in advance, regards. Fahd ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------