Rollback Segments

October 11

Hello all,
I am hoping someone can help me. I have a dev and prod
instance, with identical rollback segment specs. The problem I
have is that I am running out of space on one of my instances
(dev). The prod instances rbs's are all the same size while the
dev instance rbs's are all over the place. One rbs (in dev) may
be at 10mb and another at 800. I don't know why the size
doesn't reduce after I issue a commit. I think the problem is
that the rbs's for both instances are public and one set of
rbs's is only being used. Can any offer any suggestions? Thank



I would like to suggest 2 things :
1) make all rollback segments to same size
2) set optimal storage parameter of rollback segment.

View 2 Replies


  1. is 15 inch laptop enough for eve online
  2. sapjco3 Connect to SAP gateway failed
  3. itunes login createSession
  4. CL_SQL_RESULT_SET=============CP
  6. 7PBZ
  7. map6k3
  8. termmza
  9. overqr1
  10. showvzk
Copyrights 2019 Fcffair BigData Resource, All rights reserved