From what I see now Sweep interval does not help at all.

Database is still growing.

gstats shows that number of pages used by JMS_MESSAGES is growing with
every new set of messages generated by the application.

If I run Select against this table the number of used pages goes down
to 0 in case there is not records in the table.

So the question is will GC execute when there is no SELECT statements
at all run against JMS_MESSAGES?

In case there is only INSERT, DELETE and UPDATE statements. I'm not
sure about UPDATE.

thanks in advance

Doychin Bondzhev