Re: Is this Needed?

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: sfaroult@xxxxxxxxxxxx, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Oct 2005 12:33:48 -0400

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@xxxxxxxxxxxx> 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
>
>

Other related posts: