原帖由 viadeazhu 于 2010-8-27 10:32 发表
这题比一般面试题难多了。
parse(hard or soft or soft soft);
allocate redo buffer;
read from disk to buffer;
copy pre-image to undo;
modify buffer ; modify redo buffer;
before commit, write redo buffer to redo log;
commit;
其实还可以细分。。比如获得redo copy latch,redo write latch, redo allocation latch, cbc latch, buffer pin.
有点崇拜 小v 了!
before commit, write redo buffer to redo log; 这不是 commit 之后做的么?
[ 本帖最后由 红叶DBA 于 2010-8-27 11:50 编辑 ]
|