Oracle 10g撤销段研究  

Research of Oracle 10g Undo Segment

作　　者：谭磊[1] TAN Lei （College of Information Engineering,Chengdu University of Technology,Chengdu 610059,China）

机构地区：[1]成都理工大学信息工程学院,四川成都610059

出　　处：《电脑知识与技术》2009年第5期3345-3348,共4页Computer Knowledge and Technology

摘　　要：撤销段为oralce10g新引入的一个管理回滚数据的机制，相对于早期版本的回滚段，撤销段无论是在功能、实现机制还是管理方式上都有了很大的改变。该文通过导出撤销段头、跟踪相关撤销段数据字典等方法，深入分析了在单实例环境下的Oracle10g事务及撤销段的内部工作机制，以及撤销段的管理方法。最终来达到优化配置管理撤销段的目的，并且提出了一个预估撤销表空间大小的算法。Revocation of paragraph for the introduction of a new oralcel0g 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 dicfonary, in-depth analysis of the single-instance Oracle 10g environment affairs and revocation of the internal working mechanisms paragraph, as well as the revocation of paragraph management. Finally to achieve the optimal allocation of the management of the purposes of paragraph revoked, and revocation of a forecast table space algorithms.

关 键 词：数据库 撤销段 内部原理 表空间预估 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论;自动化与计算机技术—计算机科学与技术]