Compute Table Size

Description: Compute the overall space used by a given table (in bytes).

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='AR_DATA'
ORDER BY owner,table_name

Enjoyed this post? Share it!


Leave a comment

Your email address will not be published.