Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_LOBS

Description of the user's own LOBs contained in the user's own tables

Columns
   ___________________________
 
   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