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

I have to imagine what gets written to the redo logs in this regard has to be much smaller such as OBJ$, COL$, TAB$ etc. There's a lot of extraneous information stored in those other objects in a lot of cases such as MView logging, scheduler logging, audit data etc.

Thanks,
Chris

On Thu, Jan 4, 2024 at 6:04 AM John Thomas <jt2354_at_gmail.com> wrote:

> 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
> ------------------------------
> SYSTEM
>
> 1 row selected.
>
> Elapsed: 00:00:00.08
> SQL> SELECT SUM(bytes)/1024/1024 mb from dba_segments where
> tablespace_name = 'SYSTEM';
>
> MB
> ----------
> 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
>> 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-l