Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange applicaton problem of :Rebuild of indices

Re: Strange applicaton problem of :Rebuild of indices

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 27 Oct 2007 20:32:00 +0100
Message-ID: <dsOdnXTI65ClD77anZ2dnUVZ8qWhnZ2d@bt.com>


"nirav" <shivam71_at_gmail.com> wrote in message news:1193512513.025922.302320_at_19g2000hsx.googlegroups.com...
> Hi,
>
> We have a strange problem. From the front end a load of data is done
> into several tables (including one that has a blob in it). Now after
> this load is done several times , rebuild of indices of these tables
> must be done else the process hangs...this situation occurs in only in
> schema, but not in any other schemas that identical...can you plesase
> guide in this regard as to how I should approach the problem...being a
> dba I have access only to backend not the front end.
>
> Thanks,
> Nirav
>

Does part of the load process also include a bulk delete of a reasonably large fraction of the table.

When the process hangs, what event is it waiting on, and is it a series of short waits or a single very long wait, and does it appear to recover automatically after some time ?

-- 
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
Received on Sat Oct 27 2007 - 14:32:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US