首页 > 数据库技术 > 详细

Oracle_052_lesson_p10

时间:2018-08-22 12:38:54      阅读:149      评论:0      收藏:0      [点我收藏+]
Managing Undo Data 管理UNDO数据

you should be able to:
1、Explain DML and undo data generation
2、Monitor and administer undo data
3、Describe the difference between undo data and redo data
4、Configure undo retention
5、Guarantee undo retention
6、Use the Undo Advisor

Undo data is:
A copy of original, premodified data
Captured for every transaction that changes data
Retained at least until the transaction is ended
Used to support:
Rollback operations
Read-consistent queries
Oracle Flashback Query, Oracle Flashback Transaction, and Oracle Flashback Table
Recovery from failed transactions

有undo表空间,以段的方式存储.

Undo information is stored in undo segments, which are stored in an undo tablespace. Undo tablespaces:
Are used only for undo segments
Have special recovery considerations
May be associated with only a single instance
Require that only one of them be the current writable undo tablespace for a given instance at any given time

技术分享图片

Oracle_052_lesson_p10

原文:http://blog.51cto.com/3938853/2162778

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!