DBA_IND_PARTITIONS

SQL> DESC DBA_IND_PARTITIONS

 Name                                     Null?               Type
 ------------------------------------------------- ----------------------------
 INDEX_OWNER                                       VARCHAR2(30)
 INDEX_NAME                                         VARCHAR2(30)
 COMPOSITE                                              VARCHAR2(3)
 PARTITION_NAME                                    VARCHAR2(30)
 SUBPARTITION_COUNT                                 NUMBER
 HIGH_VALUE                                                        LONG
 HIGH_VALUE_LENGTH                                  NUMBER
 PARTITION_POSITION                                 NUMBER
 STATUS                                                        VARCHAR2(8)
 TABLESPACE_NAME                                    VARCHAR2(30)
 PCT_FREE                                                     NUMBER
 INI_TRANS                                              NUMBER
 MAX_TRANS                                         NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENT                                         NUMBER
 MAX_EXTENT                                         NUMBER
 MAX_SIZE                                                NUMBER
 PCT_INCREASE                                       NUMBER
 FREELISTS                                                  NUMBER
 FREELIST_GROUPS                                    NUMBER
 LOGGING                                           VARCHAR2(7)
 COMPRESSION                                        VARCHAR2(8)
 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
 BUFFER_POOL                                       VARCHAR2(7)
 USER_STATS                                        VARCHAR2(3)
 PCT_DIRECT_ACCESS                                  NUMBER
 GLOBAL_STATS                                       VARCHAR2(3)
 DOMIDX_OPSTATUS                                    VARCHAR2(6)
 PARAMETERS                                        VARCHAR2(1000)

No comments:

Post a Comment