Chinaunix首页 | 论坛 | 博客
  • 博客访问: 75137
  • 博文数量: 37
  • 博客积分: 2000
  • 博客等级: 大尉
  • 技术积分: 386
  • 用 户 组: 普通用户
  • 注册时间: 2009-11-11 11:33
文章分类

全部博文(37)

文章存档

2011年(1)

2010年(30)

2009年(6)

我的朋友

分类: LINUX

2010-03-10 11:29:43

来自联机文档9i
When a transaction is committed, the following occurs:
事务结束之后触发的事件:
1. The internal transaction table for the associated undo tablespace records that the
   transaction has committed, and the corresponding unique system change number
   (SCN) of the transaction is assigned and recorded in the table.
2. The log writer process (LGWR) writes redo log entries in the SGA’s redo log
   buffers to the redo log file. It also writes the transaction’s SCN to the  redo log file. This atomic event constitutes the commit of the transaction.
3. Oracle releases locks held on rows and tables.
4. Oracle marks the transaction complete.
Note: The default behavior is for LGWR to write redo to the online
redo log files synchronously and for transactions to wait for the redo
to go to disk before returning a commit to the user. However, for
lower transaction commit latency application developers can specify
that redo be written asynchronously and that transactions do not need
to wait for the redo to be on disk.
阅读(586) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~