rgilland1...@gmail.com [firebird-support] schrieb am 30.11.2015 05:10:

> Thanks Helen, 
> 
> I finally taught myself how to use isql.exe in order to access this
> information.
> What a strange tool.
> 
> 
> Then I found that both IBOConsole.exe and Upscene's Database Workbench show
> this information in Database Properties. And it is called "Allocated DB Pages"

That information is also available on the database header page, which can be 
extracted by gstat -h

So, basically, with gstat you get everything you need:

* DB total allocated pages
* Allocated pages per table
* Allocated pages per index (might be important contributors size-wise)


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

  • Re: [fire... Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
    • Re: ... 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
      • ... rgilland1...@gmail.com [firebird-support]
        • ... rgilland1...@gmail.com [firebird-support]
          • ... Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
            • ... rgilland1...@gmail.com [firebird-support]
          • ... 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
            • ... rgilland1...@gmail.com [firebird-support]
              • ... Helen Borrie hele...@iinet.net.au [firebird-support]
              • ... rgilland1...@gmail.com [firebird-support]
              • ... 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
              • ... Helen Borrie hele...@iinet.net.au [firebird-support]
              • ... hv...@users.sourceforge.net [firebird-support]
              • ... Helen Borrie hele...@iinet.net.au [firebird-support]
              • ... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]

Reply via email to