author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 07 Nov 2023 12:40:22 +0200 | |
changeset 2569 | 8f4415990863 |
parent 2568 | 77977f357b83 |
child 2570 | f1aad564e5d5 |
oracle.rst | file | annotate | diff | comparison | revisions |
--- a/oracle.rst Mon Jun 12 19:20:25 2023 +0300 +++ b/oracle.rst Tue Nov 07 12:40:22 2023 +0200 @@ -159,6 +159,14 @@ select sum(BYTES) from USER_EXTENTS; +List all tables:: + + select * from DBA_TABLES; + +List table sizes:: + + select from DBA_SEGMENTS; + Get LOB stored size:: select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;