Re: 19c Redo Generation

All the defaults are going to be running since I didnt turn off anything. I will see about dumping the op codes.

On Wed, Dec 1, 2021 at 9:29 AM Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> 1) How many of the automatic bits and pieces are still running in your 19c
> dumping diagnostic and analytical information; like possible adaptive
> stats, real-time stats, possible baselines etc.
>
> 2) Someone emailed me a couple of weeks ago to ask about redo op codes
> that they couldn't find explained anywhere - could you dump a log file and
> extract all the op codes and see if there are any which don't appear in my
> blog note on Redo OP Codes: that might be a pointer to something new that
> accounts for the difference.
>
> Regards
> Jonathan Lewis
>
>
> On Wed, 1 Dec 2021 at 15:16, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> We are on Oracle 19c with force logging turned on for a dataguard
>> standby. I dont have stats from 11g, but it seems to me that 19c is
>> generating quite a bit more redo than 11g did. Has anyone else noticed
>> this? Anyone have any numbers on it?
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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