[20180625]簡單計算日誌生成率.txt

[20180625]簡單計算日誌生成率.txt

--//執行前最好做一次日誌歸檔.主要目的瞭解正常業務時redo的生成率.
--//alter syste archive log current;

SELECT thread#
        ,sequence#
        ,first_time
        ,next_time
        ,blocks * block_size / 1024 / 1024 MB
        , (next_time - first_time) * 86400 sec
        ,  blocks
         * block_size
         / 1024
         / ( (next_time - first_time) * 86400)
            "KB/s"
    FROM v$archived_log
   WHERE     ( (next_time - first_time) * 86400 >= 1)
         AND first_time BETWEEN TRUNC (SYSDATE) - 1 AND  TRUNC (SYSDATE) + 1
         AND dest_id = 1
ORDER BY first_time;

--//注:((next_time-first_time)*86400 >=1), 取消一些快速切換的情況,避免存在大的誤差.
--//可以根據需要調整.