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]