Thursday, 26 November 2015

Re: [firebird-support] How much percentage of a database space is a table contents taking.

 

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 
Oldest snapshot 28643 
Next transaction 28644 
Bumped transaction 1 
Sequence number 0 
Next attachment ID 158 
Implementation ID 16 
Shadow count 0 
Page buffers 0 
Next header page 0 
Database dialect 3 
Creation date Nov 15, 2015 8:58:58 
Attributes force write 
 
    Variable header data: 
Sweep interval: 0 
*END* 
 
 
Database file sequence: 
File op.fdb is the only file 
 
Analyzing database pages ... 
AS_AZN_TND_TML (419) 
    Primary pointer page: 1869, Index root page: 1870 
    Data pages: 0, data page slots: 0, average fill: 0% 
    Fill distribution: 
0 - 19% = 0 
20 - 39% = 0 
40 - 59% = 0 
60 - 79% = 0 
80 - 99% = 0 

__._,_.___

Posted by: rgilland1966@gmail.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment