# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1534943063 -10800
# Node ID da95425e3010c006ecfeb3918ed7a18f7f4425e5
# Parent  7002dd57037b18c35e6b09bdacc024f38cf4e49b
Get LOB stored size.

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;