Re: Excessive archvelog creation
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 7 Sep 2017 07:43:07 -0400
Message-ID: <6f58fa15-1b59-cce8-1d6b-8a898e0218b9_at_gmail.com>
Date: Thu, 7 Sep 2017 07:43:07 -0400
Message-ID: <6f58fa15-1b59-cce8-1d6b-8a898e0218b9_at_gmail.com>
Peter, the only real way to find out is to test. That sounds like an
interesting thing to test. Please, let us know what you found out, once
you're done testing.
Regards
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-lReceived on Thu Sep 07 2017 - 13:43:07 CEST