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
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
Sequence number
Next attachment ID 158 
Implementation ID 16 
Shadow count
Page buffers
Next header page
Database dialect
Creation date Nov 15, 2015 8:58:58 
Attributes force write 
 
    Variable header data: 
Sweep interval:
*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