Get DB size and all dbfiles

[copymenad]

Hello to all IBDac user,

I make my first project with ibdac and i have two questions.

I have a Firebird-DB (split in 3 files) , which is connected via remote-connection.

How can i get the size of the complete DB (in GB / MB) ?

How can i get all filenames of the splitted db ?

I hope you can help me !

copymenad

[Dimon]

To learn about the database files and their sizes, execute the following SQL query:

Code: Select all

SELECT 
 a.MON$DATABASE_NAME, 
 (a.MON$PAGE_SIZE * a.MON$PAGES)
-- /1024 for size in Kb
FROM 
 MON$DATABASE a