diff -r 77977f357b83 -r 8f4415990863 oracle.rst --- 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;