1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
/opt/firebird/bin/gstat Ma_DB.fdb -h
Database "Ma_DB.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 76546372
Page size 4096
ODS version 10.1
Oldest transaction 76516169
Oldest active 76516170
Oldest snapshot 76516170
Next transaction 76546359
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Feb 14, 2011 10:34:38
Attributes
Variable header data:
Sweep interval: 20000
*END*
------
fb_lock_print -w | more
LOCK_HEADER BLOCK
Version: 115, Active owner: 0, Length: 262144, Used: 44372
Semmask: 0x0, Flags: 0x0001
Enqs: 6495596, Converts: 0, Rejects: 4468312, Blocks: 0
Deadlock scans: 0, Deadlocks: 0, Scan interval: 0
Acquires: 1, Acquire blocks: 0, Spin count: 3436
Mutex wait: 0.0%
Hash slots: 101, Hash lengths (min/avg/max): 0/ 1/ 8
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (31): forward: 14060, backward: 30024
Free owners (25): forward: 29304, backward: 30168
Free locks (104): forward: 18524, backward: 21164
Free requests (104): forward: 39332, backward: 40228
Lock Ordering: Enabled |
Partager