[ORACLE] 통계정보 조회

/* 테이블 */
SELECT TABLE_NAME, NUM_ROWS, CHAIN_CNT, BLOCKS, EMPTY_BLOCKS, AVG_SPACE, AVG_ROW_LEN
FROM ALL_TABLES A
WHERE OWNER = 'XXX'
;

/* 인덱스 */
SELECT TABLE_NAME, INDEX_NAME, STATUS, NUM_ROWS, LEAF_BLOCKS, BLEVEL
FROM ALL_INDEXES
WHERE OWNER = 'XXX'
;