changeset 2270 | da95425e3010 |
parent 2245 | 30d831980005 |
child 2274 | b72b5f7d98ac |
--- 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;