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
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
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 nor...@dunbar-it.co.uk 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
: [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
On Thu, May 23, 2013 at 4:31 AM, tomkrej respekt...@post.cz wrote:
Hi, I'd like to get the count of all types of db pages.
The easy answer is to use gstat which will tell you how many pages are
used by data and indexes for each table. It does not track blobs that are
larger than a page, nor
Hi,
You can use our free product DBInfo
http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo
Also, you can divide size of your database in bytes to the page size of
your database.
Regards,
Alexey Kovyazin
IBSurgeon
Hi, I'd like to get the count of all types of db pages.
If I
Hi Alexey,
thank you for this tool, it do exactly what I want.
I calculate the size of database from mon$database - as number * size of pages
- so total
count of pages I know.
Best regards, Tomas
Dne 24.5.2013 6:31, Alexey Kovyazin napsal(a):
Hi,
You can use our free product DBInfo