Oracle-L: RE: from Non-Archive-Mode to Archive-Mode

From: Adams, Matthew (GECP, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 17 Jan 2003 10:07:57 -0800
Message-ID: <F001.0053330D.20030117100757@fatcity.com>

I personally use the following SQL to
get a very rough estimate of how much
archive space I'm going to need per day.

select (num_logs*bytes )/(1024*1024) "Megs per Day" from (select ceil(avg(count(*))) num_logs from v$log_history lh

         group by trunc(lh.first_time)),
       (select avg(bytes) bytes from v$log)

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com My computer beat me at chess, but I won
when it came to kick boxing.

-----Original Message-----
Sent: Friday, January 17, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L

It depends on how much data is changed in the database. If there is no data manipulation, then you need very little archive space (just enough for the online logs when you run a backup). Look in the alert log to see how many log switches occur. I think this will give you a reasonable estimate of how much archiving will occur.

-----Original Message-----
Sent: Friday, January 17, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L

Hi,

how can I calculate/estimate the extra disk space I'll need if I change the log mode from non-archive-mode to archive-mode. I want to change the log mode of all my objects. Do I need to do this one-by-one or is it enough if I change the log mode of my tablesapces?

Thanks in advance

Murat

Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez.

This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: MURAT BALKAS
INET: murat.balkas_at_o2.net.tr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephen Lee
INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Adams, Matthew (GECP, MABG, 088130) INET: MATT.ADAMS_at_APPL.GE.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------