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

 

Hello rgilland1966@gmail.com,

Monday, November 30, 2015, 12:59:00 PM, you wrote:

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.

in isql, use SHOW DATABASE;

Read "Total Pages Allocated"

IB_SQL also shows this info, on the Characteristics tab of the Connection page.  I don't use IBExpert of DB Workbench but it would be surprising if that info is not extracted and displayed somewhere.

Helen

__._,_.___

---

Posted by: Helen Borrie <helebor@iinet.net.au>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

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

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/

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

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___