Issue Details (XML | Word | Printable)

Key: CORE-5063
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
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:

QA Status: Done successfully
Test Details:
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: Ascending order - Click to sort in descending order
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
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