Tell me more ×
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. It's 100% free, no registration required.
up vote 3 down vote favorite

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

1 Answer

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 http://docs.oracle.com/cd/B10500_01/appdev.920/a96587/qsample.htm#158007 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. docs.oracle.com/cd/B28359_01/appdev.111/b28424/… and docs.oracle.com/cd/B28359_01/server.111/b28321/… – a_horse_with_no_name Jan 19 at 20:41

Your Answer

 
discard

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.