queues and retention_time

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 4 Feb 2011 09:24:36 +0100
Message-ID: <4D4BB7C4.2070104_at_nordea.com>

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_at_nordea.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 04 2011 - 02:24:36 CST