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