2008年01月12日

10g drop table 會引起DBWn嗎

小記一下
from metalink not<286363.1>

When a truncate/drop is issued,

1.the foreground first acquires the "RO" enqueue in exclusive mode,
2.then cross instance calls (or one call if it is a single object) are issued
(the "CI" enqueue is acquired for cross instance call)
3.The CKPT processes on each of instances requests the DBWR to write
the dirty buffers to the disk and invalidate all the clean buffers.
4. After DBWR finishes writing, the foreground process releases the RO
enqueue.


來源:
http://www.itpub.net/viewthread.php?tid=921802&extra=&page=2


Posted by my_work at 樂多Roodo! │14:29 │回應(0)引用(0)DB
樂多分類:網路/3C 共同主題:Oracle 工具:編輯本文
Ads by Roodo! 

引用URL

http://cgi.blog.roodo.com/trackback/4968485