Operating System - HP-UX
1747980 Members
3663 Online
108756 Solutions
New Discussion

Re: schema table storage size

 
Yogeeraj_1
Honored Contributor

Re: schema table storage size

hi,

do you want to:
a. know how much space a table is occupying in a tablespace? or
b. the exact number of Kbytes a table is currently using?

for a:
Total space (bytes)=initial_extent+(number of extents x next_extent)

for b:
Total space (bytes)=num_rows x avg_row_len

These will give you a pretty good approximation.

to be able to use these table statistics, you should first of all gather them using, preferrably, DBMS_STATS.
e.g. exec dbms_stats.gather_table_stats( ownname => user,tabname => 'T');

hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)