Convert from Rollback segment(RBS)  to undotablespace

November 30

i have a database 9i and it using rollback segment and i would like to convert to undotablespace. question is there is anyway i can find it out what size undo i need to created base on the database right now i have it. the database is very critical i need to do it in one short and right.



As an example, if UNDO_RETENTION is set to 2 hours, and the transaction rate (UPS) is 200 undo blocks for each second, with a 4K block size, the required undo space is computed as follows:
(2 * 3600 * 200 * 4K) = 5.8GBs.
I got this piece of information from the link

View 4 Replies


  1. ipad A 1460 is disabled itunes
  2. badi or bte in sap afab transaction
  3. java deconfig for old jav r12
  4. cisco ise authentication failure
  5. I2S6
  6. surfaceqqq
  7. dullzwf
  8. negativex5u
  9. supposerzi
  10. sweetqrm
Copyrights 2019 Fcffair BigData Resource, All rights reserved