Subject Re: [firebird-support] RDB$PAGES
Author Tomas Krejzek
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
>
>
>
>