Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Rollback Segment Trans
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
![]() |
![]() |