Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_LOBS

Description of LOBs contained in tables accessible to the user

Columns
   ___________________________
 
   OWNER
      Owner of the table containing the LOB
   TABLE_NAME
      Name of the table containing the LOB
   COLUMN_NAME
      Name of the LOB column or attribute
   SEGMENT_NAME
      Name of the LOB segment
   INDEX_NAME
      Name of the LOB index
   CHUNK
      Size of the LOB chunk as a unit of allocation/manipulation in bytes
   PCTVERSION
      Maximum percentage of the LOB space used for versioning
   RETENTION
      Maximum time duration for versioning of the LOB space
   FREEPOOLS
      Number of freepools for this LOB segment
   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?

Related:



Simon Sheppard
SS64.com