oracle.rst
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;