Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RBO and Rebuild Index !!! sorry We still use RBO !!!!
On 11/1/06, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>
> Guessing a little here, but it sounds like a FIFO
> problem. Big delete, insertion of newer data,
> a thin scattering of old data left behind.
>
> If so, the cleanest fix is a coalesce after the
> delete has committed. It keeps the index
> size down, allows the maximum amount
> of space to be reclaimed, reduces the risk
> of node split failure with associated TX
> waits and redo generation.
>
>
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> From: "BN" <bnsarma_at_gmail.com>
> To: <jonathan_at_jlcomp.demon.co.uk>
> Cc: "oracle_L_list" <oracle-l_at_freelists.org>
> Sent: Tuesday, October 31, 2006 5:11 PM
> Subject: Re: RBO and Rebuild Index !!! sorry We still use RBO !!!!
> >
> > Sorry, I couldn't get back to you immediatley.
> >
> > Its a Bulk Delete every 15 minutes, they delete based on inactive flag.
> >
> >
> > --
> > Regards & Thanks
> > BN
> >
>
> Greetings
Can you please explain more what do you mean FIFO Problem
-- Regards & Thanks BN -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 02 2006 - 13:20:03 CST
![]() |
![]() |