ITPub博客

首页 > 数据库 > Oracle > SQL入门之12 Read Consistency

SQL入门之12 Read Consistency

原创 Oracle 作者:wmlm 时间:2007-04-06 12:18:51 0 删除 编辑
总结 回滚段用来保存DML时的前映像,给查询用户提供一致读,回退发生时,前映像用来写回原数据。[@more@]

When an insert, update, or delete operation is made to the database, the Oracle Server takes a copy of the data before it is changed and writes it to a undo segment.
All readers, except the one who issued the change, still see the database as it existed before the changes started; they view the undo segment’s snapshot of the data.
When a DML statement is committed, the change made to the database becomes visible to anyone executing a SELECT statement. The space occupied by the "old" data in the undo segment file is freed for reuse.
If the transaction is rolled back, the changes are undone:
The original, older version, of the data in the undo segment is written back to the table.
All users see the database as it existed before the transaction began.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/271063/viewspace-908953/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 为什么
请登录后发表评论 登录
全部评论

注册时间:2008-04-08

  • 博文量
    398
  • 访问量
    3716787