queues and retention_time
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Feb 2011 09:24:36 +0100
hi,
do You know how looks the AQ behaviour when changing down the
retention_time on a queue working for some time?
Let's say we have a 2-week retention and set to 1-week long.
Does already dequeued messages older than 1 week will be cleaned at once
or only newly dequeued messages will be cleaned after 1 week and already
existing are ruled by previous setting?
And more general question - how this cleaning looks like?
Is it done by the way of other activities or run on some schedule (for
example every X secs)?
Regards
Remigiusz
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » queues and retention_time - Remigiusz Sokolowski
