Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to create a history table for a queue table, that will store all the events of the queues, for a defined period of time ?

share|improve this question
up vote 5 down vote accepted

It seems likely to me that you could use the retention property of the queue to do this. See and also dbms_aqadm.alter_queue for details. If you really need a separate table then how about creating a multiple subscriber queue and creating an audit subscription that populates the history table. I'd use built in functionality first.

share|improve this answer
i can't use the retention time for more than 900 sec due to performance issues in our database that's i thought of a separate table. i will investigate about the audit subscription, maybe that's what i need – Khalif Dec 1 '11 at 13:15
@Khalif: What about a flashback archive? That doesn't depend on the rentention time.… and… – a_horse_with_no_name Jan 19 '13 at 20:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.