Pb with rollback segment

Advertisement
October 11

Hi guys.
Am using oracle 8i and am having problems with rollbackup segment. My rbs tablespace is 35GB and will like to shrink it! Its a production db, so my question is shoudl I fire the below query?
alter rollback segment SYSTEM shrink;
alter rollback segment RBS__BIG shrink;
alter rollback segment RBS01 shrink;
alter rollback segment RBS02 shrink;
alter rollback segment RBS03 shrink;
alter rollback segment RBS04 shrink;
alter rollback segment RBS05 shrink;
alter rollback segment RBS06 shrink;
Is there any downside? Please advice.
Thanks.

Advertisement

Replay

Hi Friend,
Production DBs are always having big transactions, These transactions obviously hold large memory in rollback segments. You will not face any issue after srinking it but if any transaction is failed and it has not been enrolled or flush out from your rollback segment. You will be not able to recover the data from rollback segment. I would suggest use share table space here instead of shrinking it. Atleast it will help to to recover current transaction in case of calamity.
Thanks,
Nitin joshi

View 5 Replies

Tags:

  1. FcffairBigDataResource
  2. Mail Version 4.6 (1085) outgoing server
  3. how to post miro for zero grn value
  4. sony kdl 42w805a netflix problem
  5. Nokia 6120c midp certificate download
  6. cfl on pdf text box in sap
  7. BExGetData
  8. sap configure ke24
  9. 7PBZ
  10. clockty7
Copyrights 2019 Fcffair BigData Resource, All rights reserved