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. how to enable mosh in Cisco routers
  2. v7 things that we dont know about coc
  3. lenovo a6000 upgrade ing problem
  4. cfl on pdf text box in sap
  5. Clash of Clans vs 11.2.3
  6. screen exist used in ml81n
  7. using outline load utility
  8. 09MY
  9. 3QVY
  10. thumb4nm
Copyrights 2019 Fcffair BigData Resource, All rights reserved