Subject Long running transactions
Author Erick Sasse
Database header page information:
Flags 0
Checksum 12345
Generation 398712
Page size 16384
ODS version 11.0
Oldest transaction 330499
Oldest active 330500
Oldest snapshot 330498
Next transaction 398706
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jun 9, 2008 11:09:24

Variable header data:
Sweep interval: 20000

Given the above information, I have some questions:

- The transaction number 330500 is still active and keeping the sweep
from running?
- Since the interval is much bigger than 20000 and counting, what
happens to the automatic sweep? Is it triggered every time the Next
transaction is raised?
- Is there always at least one active transaction per connected user
or users can be connected without any active transactions?


Erick Sasse