Database Administration (MOSC)

MOSC Banner

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center