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
Operations

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:
Relate
 

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
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