카테고리 없음
파티셔닝 고려를 위한 큰 테이블 찾기
쌀맛나는세상
2008. 1. 24. 16:59
SELECT *
FROM (SELECT segment_name, owner,
ROUND ((BYTES / 1024 / 1024 / 1024), 4) || 'GB' BYTE
FROM dba_segments
WHERE owner IN ('USER_NAME') AND segment_type = 'TABLE'
ORDER BY BYTE DESC)
WHERE ROWNUM < 20
FROM (SELECT segment_name, owner,
ROUND ((BYTES / 1024 / 1024 / 1024), 4) || 'GB' BYTE
FROM dba_segments
WHERE owner IN ('USER_NAME') AND segment_type = 'TABLE'
ORDER BY BYTE DESC)
WHERE ROWNUM < 20