Re: allocated vs. used pages (large extents)

I hate thinking of something after I've already posted an answer: If you want the number of extents as well: select systables.tabname table, sum(ss.size) allocated, npused used, npused/sum(ss.size)*100 percent_used, count(*) no_extents from sysmaster:sysextents ss, systables where ss.tabname = systables.tabname and tabid > 99 group by npused, systables.tabname cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ My pappy said "Son, you're gonna drive me to drinking if you don't stop driving that hot rod Lincoln." - CC _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________