recipients of list ORACLE-L
[EMAIL PROTECTED]
tmail.com cc:
Sent by: Subject: Re: from Non-Archive-Mode to
Archive-Mode
ORACLE-L [EMAIL PROTECTED]
tmail.com cc:
Sent by: Subject: Re: from
Non-Archive-Mode to Archive-Mode
root@fatcity.
com
January 17,
2003 05:54 PM
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
: Friday, January 17, 2003 5:08 AM
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 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
Title: RE: from Non-Archive-Mode to Archive-Mode
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
PROTECTED]
tmail.com cc:
Sent by: Subject: Re: from Non-Archive-Mode to
Archive-Mode
root@fatcity
]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Friday, January 17, 2003 1:25 PM
Subject: Re: from Non-Archive-Mode to
Archive-Mode
Arup, From your past replies to the list,
I am surprised to hear you say this. "If you have placed the init.ora
parameter log_checkpoin