[georgipa]

Hi,

Somebody can tell me how to calculate extent y next size for all tables in database (process quick).

Thank you for you help.

[nitin_math]

select tabname,
count(*)
from sysextents
where dbsname = 'DATABASE'
group by 1

Or summarised by dbspaces
select substr(DBINFO("DBSPACE",partnum),1,10) DBSpace,
dbsname[1,10] Database,
tabname[1,15] Table,
sum(pe_size) tot_space,
count(*) no_of_exts
from sysptnext, systabnames
where pe_partnum = partnum
and tabname != "TBLSpace"
group by 1,2,3
order by 1,4 desc