Re: Find Data Dictionary Size itself? Multi-tenant in this case

I think in this context "dictionary" means this: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_CAPTURE_ADM.html#GUID-4539AB47-A932-4A79-AFF5-5A42733B19DF

No idea really, how much data it would add to redo.

On Thu, 4 Jan 2024 at 12:40, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:

> 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
>
>

-- 
Ilmar Kerm

--
http://www.freelists.org/webpage/oracle-l