Schema sizes.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Wed, 08 Nov 2023 13:55:50 +0200
changeset 2570 f1aad564e5d5
parent 2569 8f4415990863
child 2571 a7c8e493887f
Schema sizes.
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;