Convert from Rollback segment(RBS)  to undotablespace

Advertisement
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.
thanks

Advertisement

Replay

Hi,
<doc>
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.
</doc>
I got this piece of information from the link
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/undo.htm
HTH
-Regards
Aditi

View 4 Replies

Tags:

  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