Re: Extents

Tony_Reynolds(Accounting & Purchasing) wrote: } } Hi, } Im doing my first extent sizing exercise in an attempt to improve } performance. } in the sysmaster database I am using the following sql: } select dbsname,tabname,count(*) number, sum(size) } from sysextents } group by dbsname,tabname } order by number desc } } Is the size the size of the extent in k - some of my figures dont } seem to add up.... } Tony Reynolds, NEC Group, Birmingham , UK 8-)) sysmaster:sysextents.size is in PAGES. If you can provide more info. regarding the figures you feel are not ok, I can try to help you. -- Vijay R. Anisetti