author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Wed, 08 Nov 2023 13:55:50 +0200 | |
changeset 2570 | f1aad564e5d5 |
parent 2569 | 8f4415990863 |
child 2571 | a7c8e493887f |
oracle.rst | file | annotate | diff | comparison | revisions |
--- 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;