How can calculate a table actual size ?

Thread: How can calculate a table actual size ?

1. Junior Member
Join Date
Jul 2000
Posts
6
Hi all,
I want to find the way to fix out this problem as title .
if you have got the good idea and solution please kindly
help me .
thanx

2. Member
Join Date
Jun 2000
Posts
104
get the values of num_rows and avg_row_size from dba_tables,after computing statistics of the table,

3. Junior Member
Join Date
Jul 2000
Posts
6
Hi drishti,
Thanks a lot .

4. Junior Member
Join Date
Aug 2000
Location
York - England
Posts
33
May I just add if you have computed statistics on the table and your optimiser mode is rule your performance could be completey foobar'd

If the Optimiser mode is rule then ANALYZE TABLE TABLE_NAME DELETE STATISTICS

If the optimiser mode is choose you may need to analyze some or all of the other tables
I hope this helps
Allan

5. gtm
Junior Member
Join Date
Nov 2000
Posts
79
After Analyzing the table, calulate the no of blocks and multiply by block size.

SELECT COUNT(DISTINCT(SUBSTR(ROWID,1,8)||SUBSTR(ROWID,15,4))) BLKS FROM TABLE_NAME ;

size = BLKS * BLOCK_SIZE

6. gtm
Junior Member
Join Date
Nov 2000
Posts
79
Another Method

After Analyzing the table, calulate the no of blocks and multiply by block size.

SELECT COUNT(DISTINCT(SUBSTR(ROWID,1,8)||SUBSTR(ROWID,15,4))) BLKS FROM TABLE_NAME ;

size = BLKS * BLOCK_SIZE

7. Junior Member
Join Date
Jul 2000
Posts
6
Hi gtm,
Thanx a lot .

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•