On 23/05/13 09:31, tomkrej wrote:
> 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

Unfortunately, you can't! This thread might help explain.
http://sourceforge.net/mailarchive/message.php?msg_id=27114737


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767