select logtime,
count(*),
round(sum(blocks * block_size) / 1024 / 1024) mbsize
from (select trunc(first_time, 'dd') as logtime, a.BLOCKS, a.BLOCK_SIZE
from v$archived_log a
where a.DEST_ID = 1
and a.FIRST_TIME > trunc(sysdate - 7))
group by logtime
order by logtime desc;
select count(*) from v$process;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31060020/viewspace-2152039/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
MySQL数据库触发器
请登录后发表评论
登录
全部评论
