Get LOB stored size.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Wed, 22 Aug 2018 16:04:23 +0300
changeset 2270 da95425e3010
parent 2269 7002dd57037b
child 2271 589a1f5f6cbd
Get LOB stored size.
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;