触发器对redo生成的影响

DML操作            AFTER触发器(10G前)     BEFORE触发器(10G以前)    AFTER触发器(10G)     BEFORE触发器(10G) 

DELETE             不影响                                 不影响                                       不影响                             不影响

INSERT             增加REDO                            增加REDO                                常量REDO                      常量REDO

UPDATE           增加REDO                             不影响                                    增加REDO                          增加REDO

在开发的时候可以考虑下

This entry was posted on 星期五, 十一月 16th, 2007 at 12:00 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«上一篇 测试REDO和BEFORCE AFTER的关系脚本
块清除(block cleanout) 下一篇»



评论暂缺

(Required)
(Required, will not be published)

CopyRight ©2007 oralife.cn, All rights reserved.
联系站长bosonmaster(at)gmail.com|QQ联系:859358
Powered by WordPress
京ICP备07026883号