Owner of the object referenced by the synonym. Although the column is called TABLE_OWNER, the object owned is not necessarily a table. It can be any general object such as a view, sequence, stored procedure, synonym, and so on.

TABLE_NAME

String

Name of the object referenced by the synonym. Although the column is called TABLE_NAME, the object does not necessarily have to be a table. It can be any general object such as a view, sequence, stored procedure, synonym, and so on.

Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used.

Indicates whether index compression is enabled (ENABLED) or not (DISABLED).

PREFIX_LENGTH

Decimal

Number of columns in the prefix of the compression key.

TABLESPACE_NAME

String

Name of the tablespace containing the index.

INI_TRANS

Decimal

Initial number of transactions.

MAX_TRANS

Decimal

Maximum number of transactions.

INITIAL_EXTENT

Decimal

Size of the initial extent.

NEXT_EXTENT

Decimal

Size of secondary extents.

MIN_EXTENTS

Decimal

Minimum number of extents allowed in the segment.

MAX_EXTENTS

Decimal

Maximum number of extents allowed in the segment.

PCT_INCREASE

Decimal

Percentage increase in extent size.

PCT_THRESHOLD

Decimal

Threshold percentage of block space allowed per index entry.

INCLUDE_COLUMN

Decimal

Column ID of the last column to be included in index-organized table primary key (non-overflow) index. This column maps to the COLUMN_ID column of the *_TAB_COLUMNS data dictionary views.

FREELISTS

Decimal

Number of process freelists allocated to this segment.

FREELIST_GROUPS

Decimal

Number of freelist groups allocated to this segment.

PCT_FREE

Decimal

Minimum percentage of free space in a block.

LOGGING

String

Logging information.

BLEVEL

Decimal

B*-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.

LEAF_BLOCKS

Decimal

Number of leaf blocks in the index.

DISTINCT_KEYS

Decimal

Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARYKEY constraints, this value is the same as the number of rows in the table (USER_TABLES.NUM_ROWS).

AVG_LEAF_BLOCKS_PER_KEY

Decimal

Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARYKEY constraints, this value is always 1.

AVG_DATA_BLOCKS_PER_KEY

Decimal

Average number of data blocks in the table that are pointed to by a distinct value in the index, rounded to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns.

CLUSTERING_FACTOR

Decimal

Indicates the amount of order of the rows in the table based on the values of the index.

STATUS

String

Indicates whether a nonpartitioned index is VALID or UNUSABLE.

NUM_ROWS

Decimal

Number of rows in the index.

SAMPLE_SIZE

Decimal

Size of the sample used to analyze the index.

LAST_ANALYZED

Date

Date on which this index was most recently analyzed.

DEGREE

String

Number of threads per instance for scanning the index.

INSTANCES

String

Number of instances across which the indexes to be scanned.

PARTITIONED

String

Indicates whether the index is partitioned (YES) or not (NO).

TEMPORARY

String

Indicates whether or not the index is on a temporary table.

GENERATED

String

Indicates whether the name of the index is system generated (Y) or not (N).

SECONDARY

String

Indicates whether the index is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N).

BUFFER_POOL

String

Name of the default buffer pool to be used for the index blocks.

USER_STATS

String

Indicates whether statistics were entered directly by the user (YES) or not (NO).

DURATION

String

Indicates the duration of a temporary table.

PCT_DIRECT_ACCESS

Decimal

For a secondary index on an index-organized table, the percentage of rows with VALID guess.

ITYP_OWNER

String

For a domain index, the owner of the index type.

ITYP_NAME

String

For a domain index, the name of the index type.

PARAMETERS

String

For a domain index, the parameter string.

GLOBAL_STATS

String

For partitioned indexes, indicates whether statistics are collected by analyzing the index as a whole (YES) or estimated from statistics on underlying index partitions and subpartitions (NO).