[#CORE-5063] Make "show database" command to show numbers of used and free pages in database

Firebird Core

Make "show database" command to show numbers of used and free pages in database

Created: 02/Jan/16 11:32 AM Updated: 03/Jan/16 09:57 PM

Component/s:

ISQL

Affects Version/s:

3.0 RC2

Fix Version/s:

3.0 RC2

Issue Links:

Relate

This issue is related to:

~~CORE-1538~~ Add an option to isc_database_info to return the number of free pages in a database

QA Status:	Done successfully
Test Details:	« Hide TEST NOT NEEDED: ... fbt-repo\tests\functional\basic\isql\isql_01.fbt does actions that exactly match for this tcket (i.e. checksoutput of SHOW DATABASE command). Show » TEST NOT NEEDED: ... fbt-repo\tests\functional\basic\isql\isql_01.fbt does actions that exactly match for this tcket (i.e. checksoutput of SHOW DATABASE command).

All

Comments

Change History

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 02/Jan/16 11:38 AM

Now, "show database" prints two more lines, as below

SQL> show database;
Database: c:\Temp\FB30.TPCC-S.300.FDB
Owner: SYSDBA
PAGE_SIZE 8192
Number of DB pages allocated = 2095520
Number of DB pages used = 2083825
Number of DB pages free = 11695
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 30376850
Transaction - oldest active = 30376851
Transaction - oldest snapshot = 30376851
Transaction - Next = 30376855
ODS = 12.0
Default Character set: NONE