Showing posts with label oracle size of cluster table. Show all posts
Showing posts with label oracle size of cluster table. Show all posts

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');