RE: Frequent logswitches
Date: Wed, 22 May 2019 08:57:12 -0400
Message-ID: <035601d5109d$dfb9e6f0$9f2db4d0$_at_rsiz.com>
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.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jack van Zanen
Sent: Wednesday, May 22, 2019 12:09 AM
Hi All
Oracle 12.2.0.1 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)
Regards
Jack van Zanen
To: oracle-l_at_freelists.org
Subject: Frequent logswitches
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 22 2019 - 14:57:12 CEST