OraFAQ Forum: Streams & AQ » Data Clean up in Persistent Queue

Home » Server Options » Streams & AQ » Data Clean up in Persistent Queue (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Clean up in Persistent Queue [message #558949]

Wed, 27 June 2012 12:25

sam5127
Messages: 17
Registered: April 2007

Junior Member

Just a simple question on the Queue Table (Persistent)

We are setting up an downstream archived re-do log streams process-

Capture and apply processes are running in the downstream database, the capture and the apply processes are using the same queue and the apply process is using a user defined DML apply handler.

All of the setup is working fine and the only issue we are noticing is that the Streams Queue table is growing.

For the capture process the checkpoint retention is 1 day.

How is the data from the Queue table cleaned up, is there any additional setup required to clean up the data?

Please let me know if you need any additional details regarding the setup.

Thanks in advance,
Sam

[Updated on: Wed, 27 June 2012 12:27]

Report message to a moderator

Re: Data Clean up in Persistent Queue [message #558980 is a reply to message #558949]

Wed, 27 June 2012 15:55

sam5127
Messages: 17
Registered: April 2007

Junior Member

Hi All,

FYI....

We are able to track down the issue related to QMON, Please refer to the attached link below - "PROCESSED Messages not being removed"

Link - https://blogs.oracle.com/db/entry/oracle_support_master_note_for_aq_queue_monitor_process_qmon_doc_id_3056621

Thanks,
Sam

Report message to a moderator

Re: Data Clean up in Persistent Queue [message #559015 is a reply to message #558980]

Wed, 27 June 2012 23:21

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Previous Topic:	DEQUEUE Option
Next Topic:	AQ messages are in ready state - Not dequeued

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 13:29:17 CDT 2025