Monday, May 27, 2013

Query high water mark in table


SELECT TABLE_NAME ,  (BLOCKS *8192 / 1024/1024 ) - (NUM_ROWS*AVG_ROW_LEN/1024/1024) "Data lower than HWM in MB"   FROM  DBA_TABLES;

No comments: