DBA_LOBS

Description of LOBs contained in all tables

Columns
   ___________________________
 
   CHUNK
      Size of the LOB chunk as a unit of allocation/manipulation in bytes
   TABLE_NAME
      Name of the table containing the LOB
   COLUMN_NAME
      Name of the LOB column or attribute
   INDEX_NAME
      Name of the LOB index
   PCTVERSION
      Maximum percentage of the LOB space used for versioning
   OWNER
      Owner of the table containing the LOB
   CACHE
      Is the LOB accessed through the buffer cache?
   LOGGING
      Are changes to the LOB logged?
   IN_ROW
      Are some of the LOBs stored with the base row?
   SEGMENT_NAME
      Name of the LOB segment

Related Commands:

Simon Sheppard
SS64.com