統計某個時間段的歸檔日誌大小
透過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部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-2137303/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 歸檔日誌大小統計
- linux查詢某段時間修改的檔案的總大小Linux
- 改變歸檔日誌檔案大小
- 查詢某時間段的統計資料
- 歸檔大小日誌計算
- rman 刪除指定時間點的歸檔日誌
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- 計算歸檔日誌所需要的磁碟空間
- 檢視歸檔日誌空間
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- Oracle歸檔日誌所在目錄時間不對&&Oracle叢集日誌時間顯示錯誤Oracle
- iOS-OC-判斷某個時間是否處於某個時間段內iOS
- 刪除歸檔,保留最近的5個歸檔日誌
- 日誌檔案的大小
- 歸檔日誌
- 【Oracle】歸檔日誌管理-設定歸檔日誌路徑以及歸檔日誌冗餘Oracle
- AIX定時刪除歸檔日誌時系統HANG住AI
- oracle歸檔模式下imp匯入資料,產生的歸檔日誌大小記錄Oracle模式
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- 查詢過去一段時間內某條sql使用的臨時表空間大小SQL
- oracle 11g 更改歸檔模式、目錄、日誌大小Oracle模式
- oracle歸檔日誌Oracle
- Oracle 歸檔日誌Oracle
- 歸檔日誌挖掘
- find 命令刪除某類或某段時間前的檔案指令碼指令碼
- 測試DML 時產生歸檔日誌和閃回日誌的比
- 歸檔日誌的刪除
- 【ARCHIVELOG】怎樣統計歸檔日誌更準確Hive
- DG邏輯庫logstdby 日誌應用長時間不歸檔
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- 控制檔案/歸檔日誌
- 歸檔日誌多歸檔路徑 duplex
- 日誌檔案和歸檔日誌檔案的關係以及如何切換日誌
- 歸檔oracle alert日誌Oracle
- 14. 日誌歸檔
- PostgreSQL歸檔日誌配置SQL
- rman清理歸檔日誌
- archive log 歸檔日誌Hive