DBA_INDEXES

Columns
   ___________________________
 
   DOMIDX_STATUS
      Is the indextype of the domain index valid
   LEAF_BLOCKS
      The number of leaf blocks in the index
   SECONDARY
      Is the index object created as part of icreate for domain indexes?
   GENERATED
      Was the name of this index system generated?
   TEMPORARY
      Can the current session only see data that it place in this object itself?
   PARTITIONED
      Is this index partitioned? YES or NO
   INSTANCES
      The number of instances across which the partitioned index is to be scanned
   DEGREE
      The number of threads per instance for scanning the partitioned index
   LAST_ANALYZED
      The date of the most recent time this index was analyzed
   SAMPLE_SIZE
      The sample size used in analyzing this index
   NUM_ROWS
   STATUS
      Whether non-partitioned index is in UNUSABLE state or not
   CLUSTERING_FACTOR
      A measurement of the amount of (dis)order of the table this index is for
   AVG_DATA_BLOCKS_PER_KEY
      The average number of data blocks per key
   BUFFER_POOL
      The default buffer pool to be used for index blocks
   DISTINCT_KEYS
      The number of distinct keys in the index
   LOGGING
      Logging attribute
   BLEVEL
      B-Tree level
   PCT_FREE
      Minimum percentage of free space in a block
   FUNCIDX_STATUS
      Is the Function-based Index DISABLED or ENABLED?
   FREELISTS
      Number of process freelists allocated in this segment
   INCLUDE_COLUMN
      User column-id for last column to be included in index-only table top index
   PCT_THRESHOLD
      Threshold percentage of block space allowed per index entry
   PCT_INCREASE
      Percentage increase in extent size
   MAX_EXTENTS
      Maximum number of extents allowed in the segment
   MIN_EXTENTS
      Minimum number of extents allowed in the segment
   NEXT_EXTENT
      Size of secondary extents
   INITIAL_EXTENT
      Size of the initial extent
   MAX_TRANS
      Maximum number of transactions
   AVG_LEAF_BLOCKS_PER_KEY
      The average number of leaf blocks per key
   COMPRESSION
      Compression property of the index: `ENABLED`,  `DISABLED`, or NULL
   FREELIST_GROUPS
      Number of freelist groups allocated to this segment
   INI_TRANS
      Initial number of transactions
   TABLESPACE_NAME
      Name of the tablespace containing the index
   USER_STATS
      Were the statistics entered directly by the user?
   PREFIX_LENGTH
      Number of key columns in the prefix used for compression
   UNIQUENESS
      Uniqueness status of the index: `UNIQUE`,  `NONUNIQUE`, or `BITMAP`
   TABLE_TYPE
      Type of the indexed object
   TABLE_NAME
      Name of the indexed object
   TABLE_OWNER
      Owner of the indexed object
   INDEX_NAME
      Name of the index
   OWNER
      Username of the owner of the index
   DOMIDX_OPSTATUS
      Status of the operation on the domain index
   GLOBAL_STATS
      Are the statistics calculated without merging underlying partitions?
   DURATION
      If index on temporary table, then duration is sys$session or sys$transaction else NULL
   PARAMETERS
      If domain index, then this is the parameter string
   ITYP_NAME
      If domain index, then this is the name of the associated indextype
   ITYP_OWNER
      If domain index, then this is the indextype owner
   PCT_DIRECT_ACCESS
      If index on IOT, then this is percentage of rows with Valid guess
   INDEX_TYPE

Related Commands: