统计某个时间段的归档日志大小
通过v$archived_log视图
V$ARCHIVED_LOG displays archived log information from the control file, including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared). If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy and whenever a copy of a log is made with the RMAN COPY command.
sql如下：
select blocks*block_size/1024/1024, blocks,block_size from v$archived_log a where a.first_time >=to_date('2017/04/09 00:00:00','yyyy-mm-dd hh24:mi:ss')
and a.first_time<=to_date('2017/04/09 23:59:59','yyyy-mm-dd hh24:mi:ss');
V$ARCHIVED_LOG displays archived log information from the control file, including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared). If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy and whenever a copy of a log is made with the RMAN COPY command.
sql如下：
select blocks*block_size/1024/1024, blocks,block_size from v$archived_log a where a.first_time >=to_date('2017/04/09 00:00:00','yyyy-mm-dd hh24:mi:ss')
and a.first_time<=to_date('2017/04/09 23:59:59','yyyy-mm-dd hh24:mi:ss');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29802484/viewspace-2137303/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
linux系统查看wwn号
请登录后发表评论
登录
全部评论
