Subject RES: [firebird-support] RDB$PAGES
Author Fabiano Kureck
Sorry is not rdb$database but another system table. I can´t remember its
name…



De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Norman Dunbar
Enviada em: quinta-feira, 23 de maio de 2013 06:35
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] RDB$PAGES





Morning Tomas,

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





[Non-text portions of this message have been removed]