查看Oracle数据库每天产生归档日志的数据量:
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);
我发现转载过来的博客上少了个“(”,但是博主设置了不允许评论,所以自己整理了重新发布出来。
查看Oracle数据库每天产生归档日志的数据量:
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);
我发现转载过来的博客上少了个“(”,但是博主设置了不允许评论,所以自己整理了重新发布出来。