Subject | Help with GSTAT output |
---|---|
Author | Stefan Heymann |
Post date | 2007-11-26T16:59:59Z |
This is from the GSTAT out from a Firebird 1.5 database (Windows
Server)
Generation 4503107
Oldest transaction 1582359
Oldest active 4503099
Oldest snapshot 4503099
Next transaction 4503100
Could somebody tell me if this (especially the difference between
"Oldest transaction" and "Oldest active") is:
( ) normal
( ) OK
( ) bad
TIA.
Regards
Stefan
P.S. Here is the complete GSTAT header:
Database header page information:
Flags 0
Checksum 12345
Generation 4503107
Page size 8192
ODS version 10.1
Oldest transaction 1582359
Oldest active 4503099
Oldest snapshot 4503099
Next transaction 4503100
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 2048
Next header page 0
Database dialect 3
Creation date Jun 1, 2007 10:47:30
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Server)
Generation 4503107
Oldest transaction 1582359
Oldest active 4503099
Oldest snapshot 4503099
Next transaction 4503100
Could somebody tell me if this (especially the difference between
"Oldest transaction" and "Oldest active") is:
( ) normal
( ) OK
( ) bad
TIA.
Regards
Stefan
P.S. Here is the complete GSTAT header:
Database header page information:
Flags 0
Checksum 12345
Generation 4503107
Page size 8192
ODS version 10.1
Oldest transaction 1582359
Oldest active 4503099
Oldest snapshot 4503099
Next transaction 4503100
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 2048
Next header page 0
Database dialect 3
Creation date Jun 1, 2007 10:47:30
Attributes force write
Variable header data:
Sweep interval: 20000
*END*