USER_IND_PENDING_STATS
仕様
PROD(JASON)> select * from v$version;

BANNER
------------------------------------------------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

PROD(JASON)> desc USER_IND_PENDING_STATS
 名前                                                            NULL?    型
 ----------------------------------------------------------------- -------- --------------------------------------------
 INDEX_NAME                                                                 VARCHAR2(30)
 TABLE_OWNER                                                                VARCHAR2(30)
 TABLE_NAME                                                                 VARCHAR2(30)
 PARTITION_NAME                                                             VARCHAR2(30)
 SUBPARTITION_NAME                                                          VARCHAR2(30)
 BLEVEL                                                                     NUMBER
 LEAF_BLOCKS                                                                NUMBER
 DISTINCT_KEYS                                                              NUMBER
 AVG_LEAF_BLOCKS_PER_KEY                                                    NUMBER
 AVG_DATA_BLOCKS_PER_KEY                                                    NUMBER
 CLUSTERING_FACTOR                                                          NUMBER
 NUM_ROWS                                                                   NUMBER
 SAMPLE_SIZE                                                                NUMBER
 LAST_ANALYZED                                                              DATE

PROD(JASON)>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License