Some AQ managed tables aren't cleared and contain loads of rows
flaviocMay 18 2012 — edited May 23 2012Hi,
I have been running a system made up of two nodes (Oracle XE 10gR2) connected by queues for a couple of years without too much hassle up to date.
Yesterday I found that two of the tables created at the time of the creation of the queue contained a few hundred thousands rows whereas the same tables in a test environment that runs almost the same data were empty. I am talking of AQ$_queue_table_name_H and $AQ_queue_table_name_I.
I stopped the propagation and when the queue was empty I truncated the content of the two tables without problems, but the question is, is there some internal Oracle process that is supposed to take care of this and for some reason is not working?
I checked the documentation but I don't find much details about housekeeping jobs.
Is the monitoring of these tables something that the DBA should add to his/her tasks?
Thanks
Flavio