Sunday, September 27, 2009

Table Size

COLUMN owner format A7
COLUMN bytes format 99999999999
BREAK ON owner ON report
COMPUTE SUM OF bytes ON owner report

SELECT owner, table_name, NVL (num_rows * avg_row_len, 0) BYTES
FROM dba_tables
WHERE tablespace_name = 'USERS'
ORDER BY owner, table_name

No comments: