I have a program which just connects to the database and waits for an
event to occur, it then handles it and waits again (see code excert
below).

The problem is that it seems to be holding the OIT, after a busy
period that didn't cause any events oldest & next transactions differ
by over 400,000, as soon as I caused an event oldest caught up.

I figure I either need to connect with different params or some
different transaction parameters but I can't see what to change.


EXEC SQL CONNECT :db_filename USER :db_username PASSWORD :db_password;

/* Go with read committed to see updates */
EXEC SQL SET TRANSACTION READ COMMITTED;

EXEC SQL EVENT INIT ALERT_WAIT ('amsalert');

while (0 == 0) /* until killed */
{

EXEC SQL EVENT WAIT ALERT_WAIT;
handle alert
}