CREATE OR REPLACE VIEW BH AS SELECT * FROM SYS.X$BH;

CREATE OR REPLACE PUBLIC SYNONYM X$BH FOR BH;

SQL> SELECT COLUMN_NAME, COMMENTS  FROM DICT_COLUMNS WHERE TABLE_NAME = ‘USER_INDEXES‘;

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

61 rows selected.