1.看下相关参数:show parameter log_
2.看下目前日志情况:select * from v$log;
3.select * from
(
select owner,object_name, value ,statistic_name
from v$segment_statistics
where statistic_name='db block changes'
order by value desc
) where rownum < 11
查看数据块的变化数,如:insert、update
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13636837/viewspace-627443/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13636837/viewspace-627443/