oradbakar
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment