Subject Re: [firebird-support] RDB$PAGES
Author
Take a look at the rdb$database table. It contains the total ammount pages
of the entire database.
Em 23/05/2013 06:34, "Norman Dunbar" <Norman@...> escreveu:

> **
>
>
> 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]