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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com