테이블별 적재 Size 조회 쿼리
Oracle 기준 테이블별 적재 Size 조회 쿼리 select table_name, num_rows, num_rows*avg_row_len, round((num_rows*avg_row_len/1024/1024),2) "SIZE(MB)", round((num_rows*avg_row_len/1024/1024/1024),2) "SIZE(GB)"from user_tables; 또는 SELECT A.SEGMENT_NAME, SUM(A.BYTES) AS SIZE_BYTES, ROUND(SUM(A.BYTES)/1024) AS SIZE_KB, ROUND(SUM(A.BYTES)/1024/1024) AS SIZE_MB, ROUND(SUM(A.BYTES)/1024/1024/1024) AS SIZE_GB, A.SEGMENT..
Oracle/DB
2013. 5. 21. 17:13