RE: Calculating archivedlog file size per day

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 14 Mar 2005 08:14:59 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0704AC0332@exchsen0a1ma>

Sami,

Wouldn't it be easier to just count the number of log file switches listed in your database alert log? Each switch is 100M (because your redo log file is 100M).

Tom

-----Original Message-----

From: Sami Seerangan [mailto:dba.orcl_at_gmail.com] Sent: Sunday, March 13, 2005 8:11 PM
To: oracle-l_at_freelists.org
Subject: Calculating archivedlog file size per day

Hi:

I want to calculate archivedlog file size per day to estimate backup storage area for the database which is currently operating in NOARCHIVELOG MODE. My redo log filesize is 100MB and below is the query.

select trunc(FIRST_TIME),count(*)*100 size_in_MB from gv$loghist
group by trunc(FIRST_TIME);

If the database is in ARCHIVELOG mode, then I can use the below query to calculate the same (of course I can check file system)

select trunc(COMPLETION_TIME),count(*)*100 size_in_MB from gv$archived_log
group by trunc(COMPLETION_TIME);

Just wanted to verify.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 14 2005 - 08:18:46 CST