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

Yes.

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

The automatic sweep will run when OAT-OIT > 20000 which is not the case
according to your statistics.

> - Is there always at least one active transaction per connected user
> or users can be connected without any active transactions?

I will leave that to others. I think it depends a bit on the toolset you
use.


Btw, you are running your database with FORCED WRITES = OFF.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com