Find Data Dictionary Size itself? Multi-tenant in this case
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 4 Jan 2024 06:38:57 -0500
Message-ID: <CAP79kiT1sChk51fdBTEiZ8QBDsaRHpM_OjNZF_ScsXG=c6eLaw_at_mail.gmail.com>
On the surface, this question may seem odd (or silly) but I realize I don't actually know how to find the size of the data dictionary itself in Oracle.
Date: Thu, 4 Jan 2024 06:38:57 -0500
Message-ID: <CAP79kiT1sChk51fdBTEiZ8QBDsaRHpM_OjNZF_ScsXG=c6eLaw_at_mail.gmail.com>
On the surface, this question may seem odd (or silly) but I realize I don't actually know how to find the size of the data dictionary itself in Oracle.
The reason this is coming up is that we're playing with Debezium and Kafka replication, and this article here wants to make sure one redo log is large enough to house the data dictionary size (so that on a log switch, every log will have a copy of the data dictionary to compare changes).
Which leads me to realizing, I don't know how to find the size of the DD itself (or have forgotten).
Article that leads me into this question: https://debezium.io/blog/2022/09/30/debezium-oracle-series-part-1/#configure-oracle-redo-logs
Thanks,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 04 2024 - 12:38:57 CET