Hi Alexey, thank you for this tool, it do exactly what I want.
I calculate the size of database from mon$database - as number * size of pages - so total count of pages I know. Best regards, Tomas Dne 24.5.2013 6:31, Alexey Kovyazin napsal(a): > Hi, > > You can use our free product DBInfo > http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo > > Also, you can divide size of your database in bytes to the page size of > your database. > > Regards, > Alexey Kovyazin > IBSurgeon > > >> Hi, I'd like to get the count of all types of db pages. >> >> If I run the query >> select count(*), rdb$page_type from rdb$pages group by rdb$page_type >> >> I got only about 2200 pages, but there are about 320 000 pages in DB. >> >> And the result of query contains only - 3, 4, 6 and 9 type of page. >> >> How can I get the real numbers?? >> >> Best regards, Tomas >> >> __ > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > >
