一般什么原因可以導致oracle數據庫歸檔日志過快增長？

通過這個語句可以查看每天的日志產生量，然后就可以看到從哪一天出現日志增長大。

SELECT TO_CHAR (first_time, 'YYYY-MM-DD WW') AS "DATE" ,TO_CHAR (first_time, 'DAY') week ,ROUND (SUM ( (blocks + 1) * block_size) / 1024 / 1024, 0) AS "SIZE_MB" ,COUNT (*) AS "NUMBER_OF_SWITCHES_PER_DAY" FROM v$archived_log WHERE dest_id = 1 and first_time>=trunc(sysdate)-40GROUP BY TO_CHAR (first_time, 'YYYY-MM-DD WW'), TO_CHAR (first_time, 'DAY')ORDER BY TO_CHAR (first_time, 'YYYY-MM-DD WW') DESC;