加载中…数据字典表：dba_indexes
(2011-11-03 22:54:26)
标签：
it |
分类： ORACLE |
关于all_indexes的详细信息可以查看oracle官方文档。dba_indexes的字段和字段描述如下：
Table: DBA_INDEXES
Description for all indexes in the database
| Column Name | Description |
|---|---|
| AVG_DATA_BLOCKS_PER_KEY | The average number of data blocks per key |
| AVG_LEAF_BLOCKS_PER_KEY | The average number of leaf blocks per key |
| BLEVEL | B-Tree level |
| BUFFER_POOL | The default buffer pool to be used for index blocks |
| CLUSTERING_FACTOR | A measurement of the amount of (dis)order of the table
this index is for |
| COMPRESSION | Compression property of the index: “ENABLED”, “DISABLED”,
or NULL |
| DEGREE | The number of threads per instance for scanning the
partitioned index |
| DISTINCT_KEYS | The number of distinct keys in the index |
| DOMIDX_OPSTATUS | Status of the operation on the domain index |
| DOMIDX_STATUS | Is the indextype of the domain index valid |
| DURATION | If index on temporary table, then duration is sys$session
or sys$transaction else NULL |
| FREELISTS | Number of process freelists allocated in this segment |
| FREELIST_GROUPS | Number of freelist groups allocated to this segment |
| FUNCIDX_STATUS | Is the Function-based Index DISABLED or ENABLED? |
| GENERATED | Was the name of this index system generated? |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| INCLUDE_COLUMN | User column-id for last column to be included in
index-only table top index |
| INDEX_NAME | Name of the index |
| INDEX_TYPE | |
| INITIAL_EXTENT | Size of the initial extent |
| INI_TRANS | Initial number of transactions |
| INSTANCES | The number of instances across which the partitioned index
is to be scanned |
| 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 |
| JOIN_INDEX | Is this index a join index? |
| LAST_ANALYZED | The date of the most recent time this index was analyzed |
| LEAF_BLOCKS | The number of leaf blocks in the index |
| LOGGING | Logging attribute |
| MAX_EXTENTS | Maximum number of extents allowed in the segment |
| MAX_TRANS | Maximum number of transactions |
| MIN_EXTENTS | Minimum number of extents allowed in the segment |
| NEXT_EXTENT | Size of secondary extents |
| NUM_ROWS | |
| OWNER | Username of the owner of the index |
| PARAMETERS | If domain index, then this is the parameter string |
| PARTITIONED | Is this index partitioned? YES or NO |
| PCT_DIRECT_ACCESS | If index on IOT, then this is percentage of rows with
Valid guess |
| PCT_FREE | Minimum percentage of free space in a block |
| PCT_INCREASE | Percentage increase in extent size |
| PCT_THRESHOLD | Threshold percentage of block space allowed per index entry |
| PREFIX_LENGTH | Number of key columns in the prefix used for compression |
| SAMPLE_SIZE | The sample size used in analyzing this index |
| SECONDARY | Is the index object created as part of icreate for domain indexes? |
| STATUS | Whether non-partitioned index is in UNUSABLE state or not |
| TABLESPACE_NAME | Name of the tablespace containing the index |
| TABLE_NAME | Name of the indexed object |
| TABLE_OWNER | Owner of the indexed object |
| TABLE_TYPE | Type of the indexed object |
| TEMPORARY | Can the current session only see data that it place in
this object itself? |
| UNIQUENESS | Uniqueness status of the index: “UNIQUE”, “NONUNIQUE”, or “BITMAP” |
| USER_STATS | Were the statistics entered directly by the user? |
喜欢
0
赠金笔
前一篇：oracle物理读和逻辑读
后一篇：Oracle之外部表