ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle查看昨天产生归档日志文件总量

oracle查看昨天产生归档日志文件总量

原创 Linux操作系统 作者:李晨超 时间:2013-03-27 12:04:51 0 删除 编辑

#查看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.
(这些归档日志文件的信息来自控制文件)
查询涉及的列名:
block_size   NUMBER      Redo log block size. This is the logical block size of the archived log,  which is the  same as the logical block size of the online log from which the archived log was opied. The online log logical block size is a platform. specific value that is not adjustable by the user. 

block        NUMBER         Size of the archived log (in blocks) 

fisrt_time   DATE             Timestamp of the first change

查看昨天日志文件产生的量(MB) 
SELECT SUM(block_size*blocks)/1024/1024/1024 "SIZE(MB)"
FROM v$archived_log 
WHERE TRUNC(first_time) >= TRUNC(sysdate-1)
AND TRUNC(first_time) < TRUNC(sysdate);

查看以前每天产生的日志文件(MB)
SELECT TRUNC(first_time) "TIME",SUM(block_size*blocks)/1024/1024/1024 "SIZE(MB)"
FROM v$archived_log
GROUP BY TRUNC(first_time);



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25756293/viewspace-757242/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: bbed的使用
请登录后发表评论 登录
全部评论

注册时间:2011-05-09

  • 博文量
    5
  • 访问量
    80746