Monday, September 13, 2010

How to findout size of cluster table (not the cluster)?

select table_name,round((blocks*16)/1024,2) "Allocate Space in MB" ,round((num_rows*avg_row_len/1024/1024/1024),2) "Used Space in GB" from dba_tables where TABLE_NAME in ('CLUSTER_TABLE');

No comments:

Post a Comment