How To Check Archive Log Size Generated per day in Oracle

If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory or disk group specified by the db_recovery_file_dest parameter.

You can use the following query to check how much archive log is generated daily. The query result will give the total generated archive log size in mb per day.

Query To Check Archive Log Size Generated per day

If you want to delete unnecessary archive logs you can read my friends article below.

Archivelog Delete Until time in Oracle Database

 

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *