Re: 19c Redo Generation

I understand. I kind of thought that was understood, since in my original question I pointed out that I dont actually have 11g stats, so I am talking about impressions rather than recorded information.

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

>
> 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.'
>>
>

-- 
Andrew W. Kerber

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

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