RE: Excessive archvelog creation
From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 7 Sep 2017 12:52:59 -0400
Message-ID: <025f01d327f9$c3b5fc20$4b21f460$_at_rsiz.com>
Date: Thu, 7 Sep 2017 12:52:59 -0400
Message-ID: <025f01d327f9$c3b5fc20$4b21f460$_at_rsiz.com>
clarification:
On 09/06/2017 02:27 PM, Schauss, Peter [US] (ES&CSO) wrote:
> So my questions are:
>
> 1. If the application was adding the data with CONCAT in small increments, say 100 characters at a time, would this account for the large volume of redo that we saw?
>
> 2. If the application had added the 48 mb all at once would it have generated less redo?
>
> Thanks,
> Peter
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 07 2017 - 18:52:59 CEST