Re: Find Data Dictionary Size itself? Multi-tenant in this case
Date: Thu, 4 Jan 2024 12:04:17 +0000
Message-ID: <CAOHpfbGRtHZVWk+RL4ZK1HfVF488+zOAbh-WWQBdSK6AUXQ3Mg_at_mail.gmail.com>
My answer may be too simplistic but something like this? (Logged in to the
CDB.)
SQL> SELECT default_tablespace from dba_users where username = 'SYS';
DEFAULT_TABLESPACE
Elapsed: 00:00:00.08
1070.75
1 row selected.
Should give you an approximation.
No doubt someone else will come back with some guidance on making every
dictionary commit complete a redo log.(If it's even possible. It could be
you have a negative impact on performance if you can configure it.)
Regards,
John Thomas
On Thu, 4 Jan 2024 at 11:39, Chris Taylor <christopherdtaylor1994_at_gmail.com>
wrote:
> On the surface, this question may seem odd (or silly) but I realize I
SYSTEM
1 row selected.
SQL> SELECT SUM(bytes)/1024/1024 mb from dba_segments where tablespace_name
= 'SYSTEM';
MB
> 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 - 13:04:17 CET