Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_LOBS

Description of LOBs contained in tables accessible to the user

Columns
   ___________________________
 
   PCTVERSION
      Maximum percentage of the LOB space used for versioning
   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
   CHUNK
      Size of the LOB chunk as a unit of allocation/manipulation in bytes
   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?
   OWNER
      Owner of the table containing the LOB
   INDEX_NAME
      Name of the LOB index

Related Commands:




Back to the Top

Simon Sheppard
SS64.com