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" <[email protected]> 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] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
