SQL> select * from dba_indexes where table_name='EZM_POOL'; OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZP SYS_C004928625 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NORMAL EZP OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZM_POOL TABLE UNIQUE DISABLED OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- USERS 2 255 65536 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 2147483645 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 10 YES OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- VALID OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 NO N Y N DEFAULT NO OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NO NO NO NO VISIBLE OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZP EZM_POOL__BLOCK_ID__TS_00001_I OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NORMAL EZP OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZM_POOL TABLE NONUNIQUE DISABLED OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- USERS 2 255 65536 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 2147483645 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 10 YES OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- VALID OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 NO N N N DEFAULT NO OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NO NO NO NO VISIBLE OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZP EZM_POOL__BLOCK_ID__TS_HIDDEN OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NORMAL EZP OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZM_POOL TABLE NONUNIQUE DISABLED OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- USERS 2 255 65536 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 2147483645 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 10 YES OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- VALID OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 NO N N N DEFAULT NO OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NO NO NO NO VISIBLE OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZP EZM_POOL__BLOCK_ID__TS_VISIBLE OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NORMAL EZP OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- EZM_POOL TABLE NONUNIQUE DISABLED OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- USERS 2 255 65536 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 2147483645 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 10 YES OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- VALID OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- 1 NO N N N DEFAULT NO OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- NO NO NO NO VISIBLE OWNER INDEX_NAME ------------------------------ ------------------------------ INDEX_TYPE TABLE_OWNER --------------------------- ------------------------------ TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ------------------------------ ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS ----------- ----------- ------------ ------------- -------------- ---------- FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS --------------- ---------- --- ---------- ----------- ------------- AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS ----------------------- ----------------------- ----------------- -------- NUM_ROWS SAMPLE_SIZE LAST_ANALY DEGREE ---------- ----------- ---------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM --- ------------ ------ -------- --- --- --- --------- -------------- SQL> spool off;