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.