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
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
引用URL
http://cgi.blog.roodo.com/trackback/4968485