RE: Calculating archivedlog file size per day

He was trying to estimate daily archive log file usage. For a quick estimate, yes, I would review the alert log to calculate this.

I rename my alert log daily, and keep them around for about a week. Who edits these files anyway?

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

From: Howard Latham [mailto:howard.latham_at_rsmb.co.uk] Sent: Monday, March 14, 2005 8:15 AM
To: thomas.mercadante_at_labor.state.ny.us; dba.orcl_at_gmail.com; oracle-l_at_freelists.org
Subject: RE: Calculating archivedlog file size per day

I really WOULDNT use a flat file that is subject to tidying up And random edits to indicate anything important - you do tidy your log files
Don't you?

Howard A. Latham

Tech Services Director UK Oracle User Group.

SENIOR DATABASE ADMINISTRATOR
RSMB Television Research Ltd,
The Communications Building,
48 Leicester Square,
London. WC2H 7LT  

Tel: +44 (0)20 7808 3619
SW:  +44 (0)20 7808 3600
Fax: +44 (0)20 7839 7446

mailto:Howard.latham_at_rsmb.co.uk

http://www.rsmb.co.uk

Email Disclaimer

This email has been sent from RSMB TV Research , a UK limited liability company. The information in
this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F Sent: 14 March 2005 13:15
To: 'dba.orcl_at_gmail.com'; oracle-l_at_freelists.org Subject: RE: Calculating archivedlog file size per day

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
--

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