156 

   156 

   157   select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS

   157   select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS

   158     group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES);

   158     group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES);

   159 

   159 

   160   select sum(BYTES) from USER_EXTENTS;

   160   select sum(BYTES) from USER_EXTENTS;

   161 

   169 

   162 Get LOB stored size::

   170 Get LOB stored size::

   163 

   171 

   164   select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;

   172   select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;

   165 

   173