diff -r 7002dd57037b -r da95425e3010 oracle.rst --- a/oracle.rst Tue Aug 21 21:15:58 2018 +0300 +++ b/oracle.rst Wed Aug 22 16:04:23 2018 +0300 @@ -159,6 +159,10 @@ select sum(BYTES) from USER_EXTENTS; +Get LOB stored size:: + + select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL; + Table indexes restricted to user:: select * from USER_INDEXES order by TABLE_NAME;