查看每天产生归档日志的数据量:
select
trunc(completion_time) as "Date"
,count(*) as "Count"
,(sum(blocks * block_size)) /1024 /1024) as "MB"
from v$archived_log
group by trunc(completion_time);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21021875/viewspace-660317/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21021875/viewspace-660317/