–테이블별 ROW COUNT 조회
SELECT TABLE_NAME, NUM_ROWS
FROM ALL_TABLES
WHERE OWNER = ‘계정명’

–테이블별 용량 조회
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BYTES)/1024/1024 AS MB
FROM DBA_SEGMENTS
WHERE 1=1
AND SEGMENT_TYPE = ‘TABLE’
AND OWNER = ‘계정명’
GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE
ORDER BY MB DESC

 

그외

— 오브젝트 조회

SELECT *

FROM ALL_OBJECTS

WHERE OBJECT_NAME LIKE ‘명’

— 테이블 조회

SELECT *

FROM ALL_TABLES

WHERE TABLE_NAME LIKE ‘명’

— 시노님 조회

SELECT *

FROM ALL_SYNONYMS

WHERE SYNONYM_NAME = ‘명’

— 테이블의 인덱스 정보

SELECT *

FROM ALL_IND_COLUMNS

WHERE TABLE_NAME = ‘테이블명’

— 테이블의 컬럼 정보

SELECT *

FROM ALL_TAB_COLUMNS

WHERE TABLE_NAME = ‘테이블명’

— TABEL COMMENT 쿼리

SELECT *

FROM ALL_TAB_COMMENTS

WHERE TABLE_NAME = ‘테이블명’

— COLUMN COMMENT 쿼리

SELECT *

FROM ALL_COL_COMMENTS

WHERE TABLE_NAME = ‘테이블명’