AQ Subscritions - large history

From: Viktor Achter <Viktor.Achter_at_gmx.de>
Date: Thu, 09 Jan 2003 11:24:12 +0100
Message-ID: <q3jq1v4g217cnsp5b50igudvn170ej664k@4ax.com>

Hi!

We are using Advanced Queues with subscription Lists. The problem is, that once a while, a subscriber doesn't unsubscribe, which seems to lead to very large AQ$_..._H Tables. We have more than 160.000 Entries for two days!
The reason for abandoned Subscriptions is, that a client subscribes on startup, and unsubscribes on normal program termination. If the Network becomes unavailable, it can't unsubscribe.

Is there a way, to make oracle delete this subscription automatically, when connection is down?

Can I forbid the AQs to use the history table?

Many thanks!

Viktor Received on Thu Jan 09 2003 - 04:24:12 CST