I have a large database.
I have some tables that I believe are unnecessary and are taking up too much
space.
I need to prove this to the boss. to be allowed to change the system.
How can I generate a report that gives me a list of table names and percentage
of overall database the table is
Hi Robert, you can do this easily with a tool such as IBExpert. Just run
Services / Database Statistics and this is the result:
TableName SizeUsage%
CUSTOMER11,960,320 0.295
PARAMFIL16,384 1 0.000
POSTCODES
> Hi Robert, you can do this easily with a tool such as IBExpert. Just run
> Services / Database Statistics and this is the result:
>
> TableName SizeUsage%
> CUSTOMER 11,960,320 0.295
> PARAMFIL 16,384 1 0.000
> POSTC
Thomas,
I ran gstat and here is the result there is no USAGE% column:
Kind Regards,
Robert.
Database "op.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 28661
Page size 8192
ODS version 11.2
Oldest transaction 25549
Oldest active 28643
Oldes
Hi,
this is an output from ibexpert, no usage% column here either:
Kind Regards,
Robert.
Database "OP.FDB"
Database header page information:
Flags 0
Checksum12345
Generation 28674
Page size
Hi Robert, you need to click on the second tab of the results - Tables.
The first tab - Text - does only show what you have here.
TableName SizeUsage%
CUSTOMER11,960,3200.295
PARAMFIL16,3840.000
POSTCODES3,903,012,86496.335
POS
rgilland1...@gmail.com [firebird-support] schrieb am 27.11.2015 00:24:
> Hi,
>
>
> this is an output from ibexpert, no usage% column here either:
>
>
> Kind Regards,
>
>
> Robert.
>
>
> Database "OP.FDB"
> Database header page information:
> Flags 0
> Chec
Hi Alan,
I have the latest personal edition of ibExpert.
And quite unfortunately.
It does not have a second tab.
Kind Regards,
Robert.
Hi Thomas,
I can see that, but how does that help me find the overall percentage of the
database size. Unless I know the total amount of pages being used by the
database. I have been googling to find out this information without much luck.
Kind Regards,
Robert.
10 matches
Mail list logo