Subject | Long running transactions |
---|---|
Author | Erick Sasse |
Post date | 2008-07-22T20:39:31Z |
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
Attributes
Variable header data:
Sweep interval: 20000
*END*
---------------
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?
Thanks
--
Erick Sasse
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
Attributes
Variable header data:
Sweep interval: 20000
*END*
---------------
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?
Thanks
--
Erick Sasse