Re: allocated vs. used pages (large extents)
Posted in 1996
Glenn, One of our available products does just what you are looking for plus a lot more. Check out http://www.ztools.com. There are 15 tools in the set. Look at zspace. Sample reports are available at the WEB site. Thanks! Greg Wilson Technology Investments, Inc (813)933-2477 Email: ztools@ztools.com In article <4mqtn9$70o@nw002.infi.net>, Glenn Travis <gtravis@richmond.infi.net> wrote: >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). > >---------------------------------------------------------------------------- >Glenn Travis gtravis@richmond.infi.net >Database Administrator gtravis@ccity.com >(Ingres/Oracle/Sybase/Informix) gtravis@aol.com >Circuit City Stores, Inc. >Richmond, VA USA http://www.infi.net/~gtravis >---------------------------------------------------------------------------- >