Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Calculating archivedlog file size per day

Calculating archivedlog file size per day

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 13 Mar 2005 20:11:13 -0500
Message-ID: <f09dd628050313171169303188@mail.gmail.com>


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
Received on Sun Mar 13 2005 - 20:14:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US