Re: Is this Needed?

Just for AQ this<https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=271855.1>script on metalin is also good.

Raj

On 10/26/05, Stephane Faroult <sfaroult_at_roughsea.com> wrote:
>
> There is something else that may benefit, namely tables that are used
> for queues and that had their high-water mark bumped much too high at a
> given moment. But copying their contents elsewhere, truncating and
> re-inserting the rows definitely don't require reorganizing the full
> database ... I agree with the general feeling: waste of time. Great
> opportunity to say "told you so".
>
> Stephane Faroult
>
>

--
http://www.freelists.org/webpage/oracle-l