Re: 19c Redo Generation
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 1 Dec 2021 12:50:23 -0500
Message-ID: <9f9cb5ac-515a-cf18-f563-7a43ce7d56c0_at_gmail.com>
Date: Wed, 1 Dec 2021 12:50:23 -0500
Message-ID: <9f9cb5ac-515a-cf18-f563-7a43ce7d56c0_at_gmail.com>
On 12/1/21 10:16, Andrew Kerber 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.'
What doV$SESSTAT and V$ACTIVE_SESSION_HISTORY say? Who is the culprit for the most of the generated redo? If you get the answer from both versions, you may be able to draw some conclusions. I no longer have anything older than 19c so I can't help you.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- http://www.freelists.org/webpage/oracle-l Received on Wed Dec 01 2021 - 18:50:23 CET