Finding size of LOB where LOB column of the table points to a TYPE
Hello all
In our 19c database we have a table called BIG_TABLE
SQL> desc BIG_TABLE
Name Null? Type
ID NOT NULL NUMBER(38)
ACTION_CODE NOT NULL CHAR(1)
ACTION_DT NOT NULL DATE
AUSER NOT NULL VARCHAR2(30)
FILE_STORAGE APPS.BLOB_T
When we query dba_lobs and dba_segments we get this result for the LOBS belonging to that table
select a.owner,a.table_name,a.column_name,a.segment_name,a.tablespace_name,a.index_name,b.bytes/1024/1024/1024 GB
from
dba_lobs a, dba_segments b
where a.segment_name=b.segment_name
and
a.owner in='APPS' and a.table_name='BIG_TABLE'