Oracle 10g撤销段研究

撤销段为oralce10g新引入的一个管理回滚数据的机制,相对于早期版本的回滚段,撤销段无论是在功能、实现机制还是管理方式上都有了很大的改变。该文通过导出撤销段头、跟踪相关撤销段数据字典等方法,深入分析了在单实例环境下的Oracle10g事务及撤销段的内部工作机制,以及撤销段的管理方法。最终来达到优化配置管理撤销段的目的,并且提出了一个预估撤销表空间大小的算法。

Research of Oracle 10g Undo Segment

Revocation of paragraph for the introduction of a new oralce10g rollback data management mechanisms,as opposed to early versions of the rollback segment to remove the paragraph whether in the function,mechanism of implementation or management methods have led to great changes.Through the Export revoked the first paragraph,related to revocation of paragraph tracking methods such as data dictionary,in-depth analysis of the single-instance Oracle 10g environment affairs and revocation of the internal working m...