RE: Frequent logswitches

From: Mark W. Farnham <>
Date: Wed, 22 May 2019 08:57:12 -0400
Message-ID: <035601d5109d$dfb9e6f0$9f2db4d0$>

The most pedestrian way is to set up a second container database and move one pdb back and forth at a time running it in the other container long enough to determine how much redo it generates.  

This will double the number of non-PDB processes (that is the container infrastructure) whenever both container are running, so you may or may not have sufficient headroom on memory and so forth.  

The answer, though, should be quite precise.  

There are probably other ways to make this measurement that do not involve re-plugging.  


From: [] On Behalf Of Jack van Zanen Sent: Wednesday, May 22, 2019 12:09 AM
Subject: Frequent logswitches  

Hi All    

Oracle Multitennant database RAC  

Is there a way to figure out which PDB is mostly responsible for the generation of REDO?  

On that same topic:  

Is it normal to have the DBW and LMS processes to have the largest redo size?

(I guess it is)  


Jack van Zanen  

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
Received on Wed May 22 2019 - 14:57:12 CEST

Original text of this message