Re: 19c Redo Generation

I should have started my comment with the warning that it was just speculation, not prior observation of actual events.

Regards
Jonathan Lewis

On Wed, 1 Dec 2021 at 15:33, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> 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