Friday, October 22, 2010

calculate Table size usage in Oracle Database

This script shows able size usage in Oracle Database

select TABLE_NAME, ROUND((AVG_ROW_LEN * NUM_ROWS / 1024), 2) SIZE_KB from USER_TABLES order by TABLE_NAMEView Blog

No comments:

Post a Comment