Subject | Re: [firebird-support] internal gds consistency... |
---|---|
Author | leugim@poczta.onet.pl |
Post date | 2007-08-29T12:35:16Z |
Hello!
Ann W. Harrison pisze:
CON> from RDB$PAGES
CON> group by rdb$relation_id, rdb$page_type
CON> order by 3 desc ;
RDB$RELATION_ID RDB$PAGE_TYPE COUNT
=============== ============= ============
0 3 1395
134 4 606
135 4 47
166 4 12
162 4 11
142 4 2
Best regards,
...michal
Ann W. Harrison pisze:
> that's not likely to be the cause. How many pointer pagesSQL> select rdb$relation_id, rdb$page_type, count(*)
> are there in that table?
CON> from RDB$PAGES
CON> group by rdb$relation_id, rdb$page_type
CON> order by 3 desc ;
RDB$RELATION_ID RDB$PAGE_TYPE COUNT
=============== ============= ============
0 3 1395
134 4 606
135 4 47
166 4 12
162 4 11
142 4 2
Best regards,
...michal