diff -r 8f4415990863 -r f1aad564e5d5 oracle.rst --- a/oracle.rst Tue Nov 07 12:40:22 2023 +0200 +++ b/oracle.rst Wed Nov 08 13:55:50 2023 +0200 @@ -167,6 +167,12 @@ select from DBA_SEGMENTS; +Schema sizes:: + + select OWNER, sum(BYTES)/1024/1024 as MiB + from DBA_SEGMENTS + group by OWNER; + Get LOB stored size:: select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;