Undo Tablespace queries
837382Feb 7 2011 — edited Feb 7 2011Hi All,
I am bit confused with reading about the undo table space. so i need some clarification
1. There are 2 undo tablespace in our application. Could someone explain how the 2 undo tablespace works? I didn't find any details about this.
2. Both the undo tablespace is 100% utilized. Where the the new transaction will go? Will new transaction force the used blocks to be expired if needed?
3. What should be the ideal size of undo tablespace with respect to the total storage size?
4. is Archive log related to undotable space? if yes then When the archive logs get generated?
Thanks