数据库版本:10.2.0.3
OS:rhel4 U 4
10G中每15分钟smon会将sga中保存的修改数据资料flush到XXX_table_modifications中,但我测试发现oracle并没有这样做.
Monitoring tracks the approximate number of INSERT, UPDATE, and DELETE
operations for the table since the last time statistics were gathered.
information about how many rows are affected is maintained in the SGA,
until periodically (about every 15 minutes) SMON flush the data into the data
dictionary.
而是晚上22:00时才flush了一次.测试过程就不贴了,我写了个脚本只要all_table_modifications有更新的话就会写一笔资料到定义的表中.
怀疑是不是10.2.0.3的bug?
[ 本帖最后由 jolly10 于 2008-5-23 10:18 编辑 ]
OS:rhel4 U 4
10G中每15分钟smon会将sga中保存的修改数据资料flush到XXX_table_modifications中,但我测试发现oracle并没有这样做.
Monitoring tracks the approximate number of INSERT, UPDATE, and DELETE
operations for the table since the last time statistics were gathered.
information about how many rows are affected is maintained in the SGA,
until periodically (about every 15 minutes) SMON flush the data into the data
dictionary.
而是晚上22:00时才flush了一次.测试过程就不贴了,我写了个脚本只要all_table_modifications有更新的话就会写一笔资料到定义的表中.
怀疑是不是10.2.0.3的bug?
[ 本帖最后由 jolly10 于 2008-5-23 10:18 编辑 ]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271283/viewspace-419080/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
oem连不上
请登录后发表评论
登录
全部评论
