Re: archive logs

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Tue, 24 May 2016 13:56:41 +1000
Message-ID: <CAFeFPA8pK9-6AupM_eXA+WT3n1jaKeVfWHxOS_bh1nYfUGakRw_at_mail.gmail.com>

Hi

This probably provides the info required, but on a very busy period there may be more frequent log switches

so when you setup this report

"ARCHIVE_LAG_TARGET =600" for instance forces a log switch every 10 minutes but you could have one every 5 or 2 or 1 minutes if system is very busy. So unlike SQL Server where it is fixed by a schedule, within oracle it is handled by the size of the online redo log files, number of changes happening, setting of ARCHIVE_LAG_TARGET and probably a few more things.

Jack

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

On Sat, May 21, 2016 at 4:51 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> ARCHIVE_LAG_TARGET I meant....
>
> Chris
>
>
> On Fri, May 20, 2016 at 1:50 PM, Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> lag_archive_target for the win.
>>
>> Chris
>>
>>
>>

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

Received on Tue May 24 2016 - 05:56:41 CEST