Re: allocated vs. used pages (large extents)

> > Has anyone written a report showing the pages allocated vs.pages used by a > table/index? Like Oracle, I want to keep my unused space to a minimum and > re-build when necessary (into one extent). > Good need. I like it and am posting in general as well. If you are using a current online engine then the following does what you want: select systables.tabname table, sum(ss.size) allocated, npused used, npused/sum(ss.size)*100 percent_used from sysmaster:sysextents ss, systables where ss.tabname = systables.tabname and tabid > 99 group by npused, systables.tabname If not holler at me, I have some old code you can muck with. 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. _____________________________________________________________________________